CREATE FUNCTION "EXPORT"."B_TKCONTAINER" ( "TYPE_DEF"	SMALLINT )
     RETURNS TABLE (
...........................
BEGIN ATOMIC 
DECLARE................

RETURN
WITH T AS (
  SELECT A.TKCONTAINER TKCONTAINER
	FROM (SELECT TKCONTAINER, MIN(TKSESS) S1, MAX(TKSESS) S2 
FROM POLICY.POLCONTSESS WHERE TKEXPORT BETWEEN MIN_TKEXPORT_VAR AND MAX_TKEXPORT_VAR GROUP BY TKCONTAINER) S ,
POLICY.A1AGRE A 
)
SELECT 
	EXPORT.A1AGRX_CONVTYPE ( T.TKCONTAINER ),
	EXPORT.A1AGRS_STATUS ( T.TKCONTAINER ) AS GRS_STATUS,
	EXPORT.A1AGRS_SUBSTATUS ( T.TKCONTAINER ) AS GRS_SUBSTATUS,
	EXPORT.A1AGRS_STARTTS ( T.TKCONTAINER, TYPE_DEF, SUBTYPE_DEF ) AS GRS_STARTTS,
	EXPORT.A1AGRS_STARTTS_OFF ( T.TKCONTAINER ) AS GRS_STARTTS_OFFER ,
	EXPORT.A1AGRR_PAYMENTMETH ( T.TKCONTAINER ) AS GRR_PAYMENTMETHOD,
	EXPORT.A1PPLE_PAYMENTTYPE ( T.TKCONTAINER ) AS PPLE_PAYMENTTYPE ,
	EXPORT.A1PEPE_PENSIONFREQ ( T.TKCONTAINER ) AS PEPE_PENSIONFREQUENCY ,
	EXPORT.A1BENC_UNREVOKABLE ( T.TKCONTAINER ) AS BENC_UNREVOKABLE ,

	EXPORT.A1AGRE_PLEDGED ( T.TKCONTAINER ) AS AGRE_PLEDGED ,
	EXPORT.A1PPL_INDEXTYPE ( T.TKCONTAINER ) AS PPL_INDEXTYPE ,
	EXPORT.A1PPL_INDEXVALUE ( T.TKCONTAINER ) AS PPL_INDEXVALUE ,
	EXPORT.A1LBCO_COMPANYID ( T.TKCONTAINER ) AS LBCO_COMPANYID,  
	EXPORT.A1LBCO_COMPANYID_P ( T.TKCONTAINER ) AS LBCO_COMPANYID_PREV ,
	EXPORT.A1SDAE_AGENTID_1 ( T.TKCONTAINER ) AS SDAE_AGENTID_FIRST ,
	EXPORT.A1SDAE_AGENTID_CUR ( T.TKCONTAINER ) AS SDAE_AGENTID_CURRENT ,
	EXPORT.C1CLNT_AGRR20 ( T.TKCONTAINER ) AS CLNT_EXTID_AGRR20 ,
	EXPORT.C1CLNT_AGRR10 ( T.TKCONTAINER ) AS CLNT_EXTID_AGRR10 ,
	EXPORT.C1CLNT_PROR10 ( T.TKCONTAINER ) AS CLNT_EXTID_PROR10 ,
	EXPORT.C1CLNT_AGRR70 ( T.TKCONTAINER ) AS CLNT_EXTID_AGRR70 ,
	EXPORT.A1AGRR_PERSON_COMP ( T.TKCONTAINER ) AS AGRR_PERSONORCOMPANY ,
	EXPORT.A1PROR_BIRTHDATE ( T.TKCONTAINER ) AS PROR_BIRTHDATE,
	EXPORT.A1PROR_SEX ( T.TKCONTAINER ) AS PROR_SEX
	FROM T
;
END;