[Home] [Help]
465: fetch c_find_EAN_in_target into l_new_value ;
466: if c_find_EAN_in_target%found then
467: --
468: --TEMPIK
469: l_dt_rec_found := dt_api.check_min_max_dates
470: (p_base_table_name => 'BEN_ELIG_ASNT_SET_PRTE_F',
471: p_base_key_column => 'ELIG_ASNT_SET_PRTE_ID',
472: p_base_key_value => l_new_value,
473: p_from_date => l_min_esd,
983: fetch c_find_CGP_in_target into l_new_value ;
984: if c_find_CGP_in_target%found then
985: --
986: --TEMPIK
987: l_dt_rec_found := dt_api.check_min_max_dates
988: (p_base_table_name => 'BEN_CNTNG_PRTN_ELIG_PRFL_F',
989: p_base_key_column => 'CNTNG_PRTN_ELIG_PRFL_ID',
990: p_base_key_value => l_new_value,
991: p_from_date => l_min_esd,
1475: fetch c_find_EAP_in_target into l_new_value ;
1476: if c_find_EAP_in_target%found then
1477: --
1478: --TEMPIK
1479: l_dt_rec_found := dt_api.check_min_max_dates
1480: (p_base_table_name => 'BEN_ELIG_AGE_PRTE_F',
1481: p_base_key_column => 'ELIG_AGE_PRTE_ID',
1482: p_base_key_value => l_new_value,
1483: p_from_date => l_min_esd,
1966: fetch c_find_EBN_in_target into l_new_value ;
1967: if c_find_EBN_in_target%found then
1968: --
1969: --TEMPIK
1970: l_dt_rec_found := dt_api.check_min_max_dates
1971: (p_base_table_name => 'BEN_ELIG_BENFTS_GRP_PRTE_F',
1972: p_base_key_column => 'ELIG_BENFTS_GRP_PRTE_ID',
1973: p_base_key_value => l_new_value,
1974: p_from_date => l_min_esd,
2459: fetch c_find_EBU_in_target into l_new_value ;
2460: if c_find_EBU_in_target%found then
2461: --
2462: --TEMPIK
2463: l_dt_rec_found := dt_api.check_min_max_dates
2464: (p_base_table_name => 'BEN_ELIG_BRGNG_UNIT_PRTE_F',
2465: p_base_key_column => 'ELIG_BRGNG_UNIT_PRTE_ID',
2466: p_base_key_value => l_new_value,
2467: p_from_date => l_min_esd,
2949: fetch c_find_ECL_in_target into l_new_value ;
2950: if c_find_ECL_in_target%found then
2951: --
2952: --TEMPIK
2953: l_dt_rec_found := dt_api.check_min_max_dates
2954: (p_base_table_name => 'BEN_ELIG_COMP_LVL_PRTE_F',
2955: p_base_key_column => 'ELIG_COMP_LVL_PRTE_ID',
2956: p_base_key_value => l_new_value,
2957: p_from_date => l_min_esd,
3442: fetch c_find_ECP_in_target into l_new_value ;
3443: if c_find_ECP_in_target%found then
3444: --
3445: --TEMPIK
3446: l_dt_rec_found := dt_api.check_min_max_dates
3447: (p_base_table_name => 'BEN_ELIG_CMBN_AGE_LOS_PRTE_F',
3448: p_base_key_column => 'ELIG_CMBN_AGE_LOS_PRTE_ID',
3449: p_base_key_value => l_new_value,
3450: p_from_date => l_min_esd,
3953: fetch c_find_ECQ_in_target into l_new_value ;
3954: if c_find_ECQ_in_target%found then
3955: --
3956: --TEMPIK
3957: l_dt_rec_found := dt_api.check_min_max_dates
3958: (p_base_table_name => 'BEN_ELIG_CBR_QUALD_BNF_F',
3959: p_base_key_column => 'ELIG_CBR_QUALD_BNF_ID',
3960: p_base_key_value => l_new_value,
3961: p_from_date => l_min_esd,
4489: fetch c_find_ECY_in_target into l_new_value ;
4490: if c_find_ECY_in_target%found then
4491: --
4492: --TEMPIK
4493: l_dt_rec_found := dt_api.check_min_max_dates
4494: (p_base_table_name => 'BEN_ELIG_COMPTNCY_PRTE_F',
4495: p_base_key_column => 'ELIG_COMPTNCY_PRTE_ID',
4496: p_base_key_value => l_new_value,
4497: p_from_date => l_min_esd,
5079: fetch c_find_EDG_in_target into l_new_value ;
5080: if c_find_EDG_in_target%found then
5081: --
5082: --TEMPIK
5083: l_dt_rec_found := dt_api.check_min_max_dates
5084: (p_base_table_name => 'BEN_ELIG_DPNT_CVRD_OTHR_PGM_F',
5085: p_base_key_column => 'ELIG_DPNT_CVRD_OTHR_PGM_ID',
5086: p_base_key_value => l_new_value,
5087: p_from_date => l_min_esd,
5585: fetch c_find_EDI_in_target into l_new_value ;
5586: if c_find_EDI_in_target%found then
5587: --
5588: --TEMPIK
5589: l_dt_rec_found := dt_api.check_min_max_dates
5590: (p_base_table_name => 'BEN_ELIG_DPNT_CVRD_PLIP_F',
5591: p_base_key_column => 'ELIG_DPNT_CVRD_PLIP_ID',
5592: p_base_key_value => l_new_value,
5593: p_from_date => l_min_esd,
6084: fetch c_find_EDP_in_target into l_new_value ;
6085: if c_find_EDP_in_target%found then
6086: --
6087: --TEMPIK
6088: l_dt_rec_found := dt_api.check_min_max_dates
6089: (p_base_table_name => 'BEN_ELIG_DPNT_CVRD_OTHR_PL_F',
6090: p_base_key_column => 'ELIG_DPNT_CVRD_OTHR_PL_ID',
6091: p_base_key_value => l_new_value,
6092: p_from_date => l_min_esd,
6582: fetch c_find_EDT_in_target into l_new_value ;
6583: if c_find_EDT_in_target%found then
6584: --
6585: --TEMPIK
6586: l_dt_rec_found := dt_api.check_min_max_dates
6587: (p_base_table_name => 'BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F',
6588: p_base_key_column => 'ELIG_DPNT_CVRD_OTHR_PTIP_ID',
6589: p_base_key_value => l_new_value,
6590: p_from_date => l_min_esd,
7079: fetch c_find_ERL_in_target into l_new_value ;
7080: if c_find_ERL_in_target%found then
7081: --
7082: --TEMPIK
7083: l_dt_rec_found := dt_api.check_min_max_dates
7084: (p_base_table_name => 'BEN_ELIGY_PRFL_RL_F',
7085: p_base_key_column => 'ELIGY_PRFL_RL_ID',
7086: p_base_key_value => l_new_value,
7087: p_from_date => l_min_esd,
7574: fetch c_find_EHW_in_target into l_new_value ;
7575: if c_find_EHW_in_target%found then
7576: --
7577: --TEMPIK
7578: l_dt_rec_found := dt_api.check_min_max_dates
7579: (p_base_table_name => 'BEN_ELIG_HRS_WKD_PRTE_F',
7580: p_base_key_column => 'ELIG_HRS_WKD_PRTE_ID',
7581: p_base_key_value => l_new_value,
7582: p_from_date => l_min_esd,
8088: fetch c_find_EJP_in_target into l_new_value ;
8089: if c_find_EJP_in_target%found then
8090: --
8091: --TEMPIK
8092: l_dt_rec_found := dt_api.check_min_max_dates
8093: (p_base_table_name => 'BEN_ELIG_JOB_PRTE_F',
8094: p_base_key_column => 'ELIG_JOB_PRTE_ID',
8095: p_base_key_value => l_new_value,
8096: p_from_date => l_min_esd,
8582: fetch c_find_ELU_in_target into l_new_value ;
8583: if c_find_ELU_in_target%found then
8584: --
8585: --TEMPIK
8586: l_dt_rec_found := dt_api.check_min_max_dates
8587: (p_base_table_name => 'BEN_ELIG_LBR_MMBR_PRTE_F',
8588: p_base_key_column => 'ELIG_LBR_MMBR_PRTE_ID',
8589: p_base_key_value => l_new_value,
8590: p_from_date => l_min_esd,
9094: fetch c_find_ELN_in_target into l_new_value ;
9095: if c_find_ELN_in_target%found then
9096: --
9097: --TEMPIK
9098: l_dt_rec_found := dt_api.check_min_max_dates
9099: (p_base_table_name => 'BEN_ELIG_LGL_ENTY_PRTE_F',
9100: p_base_key_column => 'ELIG_LGL_ENTY_PRTE_ID',
9101: p_base_key_value => l_new_value,
9102: p_from_date => l_min_esd,
9643: fetch c_find_ELR_in_target into l_new_value ;
9644: if c_find_ELR_in_target%found then
9645: --
9646: --TEMPIK
9647: l_dt_rec_found := dt_api.check_min_max_dates
9648: (p_base_table_name => 'BEN_ELIG_LOA_RSN_PRTE_F',
9649: p_base_key_column => 'ELIG_LOA_RSN_PRTE_ID',
9650: p_base_key_value => l_new_value,
9651: p_from_date => l_min_esd,
10145: fetch c_find_ELS_in_target into l_new_value ;
10146: if c_find_ELS_in_target%found then
10147: --
10148: --TEMPIK
10149: l_dt_rec_found := dt_api.check_min_max_dates
10150: (p_base_table_name => 'BEN_ELIG_LOS_PRTE_F',
10151: p_base_key_column => 'ELIG_LOS_PRTE_ID',
10152: p_base_key_value => l_new_value,
10153: p_from_date => l_min_esd,
10640: fetch c_find_ELV_in_target into l_new_value ;
10641: if c_find_ELV_in_target%found then
10642: --
10643: --TEMPIK
10644: l_dt_rec_found := dt_api.check_min_max_dates
10645: (p_base_table_name => 'BEN_ELIG_LVG_RSN_PRTE_F',
10646: p_base_key_column => 'ELIG_LVG_RSN_PRTE_ID',
10647: p_base_key_value => l_new_value,
10648: p_from_date => l_min_esd,
11136: fetch c_find_EMP_in_target into l_new_value ;
11137: if c_find_EMP_in_target%found then
11138: --
11139: --TEMPIK
11140: l_dt_rec_found := dt_api.check_min_max_dates
11141: (p_base_table_name => 'BEN_ELIG_MRTL_STS_PRTE_F',
11142: p_base_key_column => 'ELIG_MRTL_STS_PRTE_ID',
11143: p_base_key_value => l_new_value,
11144: p_from_date => l_min_esd,
11629: fetch c_find_ENO_in_target into l_new_value ;
11630: if c_find_ENO_in_target%found then
11631: --
11632: --TEMPIK
11633: l_dt_rec_found := dt_api.check_min_max_dates
11634: (p_base_table_name => 'BEN_ELIG_NO_OTHR_CVG_PRTE_F',
11635: p_base_key_column => 'ELIG_NO_OTHR_CVG_PRTE_ID',
11636: p_base_key_value => l_new_value,
11637: p_from_date => l_min_esd,
12115: fetch c_find_EOM_in_target into l_new_value ;
12116: if c_find_EOM_in_target%found then
12117: --
12118: --TEMPIK
12119: l_dt_rec_found := dt_api.check_min_max_dates
12120: (p_base_table_name => 'BEN_ELIG_OPTD_MDCR_PRTE_F',
12121: p_base_key_column => 'ELIG_OPTD_MDCR_PRTE_ID',
12122: p_base_key_value => l_new_value,
12123: p_from_date => l_min_esd,
12619: fetch c_find_EOU_in_target into l_new_value ;
12620: if c_find_EOU_in_target%found then
12621: --
12622: --TEMPIK
12623: l_dt_rec_found := dt_api.check_min_max_dates
12624: (p_base_table_name => 'BEN_ELIG_ORG_UNIT_PRTE_F',
12625: p_base_key_column => 'ELIG_ORG_UNIT_PRTE_ID',
12626: p_base_key_value => l_new_value,
12627: p_from_date => l_min_esd,
13123: fetch c_find_EOY_in_target into l_new_value ;
13124: if c_find_EOY_in_target%found then
13125: --
13126: --TEMPIK
13127: l_dt_rec_found := dt_api.check_min_max_dates
13128: (p_base_table_name => 'BEN_ELIG_OTHR_PTIP_PRTE_F',
13129: p_base_key_column => 'ELIG_OTHR_PTIP_PRTE_ID',
13130: p_base_key_value => l_new_value,
13131: p_from_date => l_min_esd,
13620: fetch c_find_EPF_in_target into l_new_value ;
13621: if c_find_EPF_in_target%found then
13622: --
13623: --TEMPIK
13624: l_dt_rec_found := dt_api.check_min_max_dates
13625: (p_base_table_name => 'BEN_ELIG_PCT_FL_TM_PRTE_F',
13626: p_base_key_column => 'ELIG_PCT_FL_TM_PRTE_ID',
13627: p_base_key_value => l_new_value,
13628: p_from_date => l_min_esd,
14141: fetch c_find_EPT_in_target into l_new_value ;
14142: if c_find_EPT_in_target%found then
14143: --
14144: --TEMPIK
14145: l_dt_rec_found := dt_api.check_min_max_dates
14146: (p_base_table_name => 'BEN_ELIG_PER_TYP_PRTE_F',
14147: p_base_key_column => 'ELIG_PER_TYP_PRTE_ID',
14148: p_base_key_value => l_new_value,
14149: p_from_date => l_min_esd,
14651: fetch c_find_EPG_in_target into l_new_value ;
14652: if c_find_EPG_in_target%found then
14653: --
14654: --TEMPIK
14655: l_dt_rec_found := dt_api.check_min_max_dates
14656: (p_base_table_name => 'BEN_ELIG_PPL_GRP_PRTE_F',
14657: p_base_key_column => 'ELIG_PPL_GRP_PRTE_ID',
14658: p_base_key_value => l_new_value,
14659: p_from_date => l_min_esd,
15162: fetch c_find_EPB_in_target into l_new_value ;
15163: if c_find_EPB_in_target%found then
15164: --
15165: --TEMPIK
15166: l_dt_rec_found := dt_api.check_min_max_dates
15167: (p_base_table_name => 'BEN_ELIG_PY_BSS_PRTE_F',
15168: p_base_key_column => 'ELIG_PY_BSS_PRTE_ID',
15169: p_base_key_value => l_new_value,
15170: p_from_date => l_min_esd,
15670: fetch c_find_EPN_in_target into l_new_value ;
15671: if c_find_EPN_in_target%found then
15672: --
15673: --TEMPIK
15674: l_dt_rec_found := dt_api.check_min_max_dates
15675: (p_base_table_name => 'BEN_ELIG_PRBTN_PERD_PRTE_F',
15676: p_base_key_column => 'ELIG_PRBTN_PERD_PRTE_ID',
15677: p_base_key_value => l_new_value,
15678: p_from_date => l_min_esd,
16176: fetch c_find_EPP_in_target into l_new_value ;
16177: if c_find_EPP_in_target%found then
16178: --
16179: --TEMPIK
16180: l_dt_rec_found := dt_api.check_min_max_dates
16181: (p_base_table_name => 'BEN_ELIG_PRTT_ANTHR_PL_PRTE_F',
16182: p_base_key_column => 'ELIG_PRTT_ANTHR_PL_PRTE_ID',
16183: p_base_key_value => l_new_value,
16184: p_from_date => l_min_esd,
16676: fetch c_find_EPS_in_target into l_new_value ;
16677: if c_find_EPS_in_target%found then
16678: --
16679: --TEMPIK
16680: l_dt_rec_found := dt_api.check_min_max_dates
16681: (p_base_table_name => 'BEN_ELIG_PSTN_PRTE_F',
16682: p_base_key_column => 'ELIG_PSTN_PRTE_ID',
16683: p_base_key_value => l_new_value,
16684: p_from_date => l_min_esd,
17192: fetch c_find_EPY_in_target into l_new_value ;
17193: if c_find_EPY_in_target%found then
17194: --
17195: --TEMPIK
17196: l_dt_rec_found := dt_api.check_min_max_dates
17197: (p_base_table_name => 'BEN_ELIG_PYRL_PRTE_F',
17198: p_base_key_column => 'ELIG_PYRL_PRTE_ID',
17199: p_base_key_value => l_new_value,
17200: p_from_date => l_min_esd,
17685: fetch c_find_EPZ_in_target into l_new_value ;
17686: if c_find_EPZ_in_target%found then
17687: --
17688: --TEMPIK
17689: l_dt_rec_found := dt_api.check_min_max_dates
17690: (p_base_table_name => 'BEN_ELIG_PSTL_CD_R_RNG_PRTE_F',
17691: p_base_key_column => 'ELIG_PSTL_CD_R_RNG_PRTE_ID',
17692: p_base_key_value => l_new_value,
17693: p_from_date => l_min_esd,
18189: fetch c_find_EQT_in_target into l_new_value ;
18190: if c_find_EQT_in_target%found then
18191: --
18192: --TEMPIK
18193: l_dt_rec_found := dt_api.check_min_max_dates
18194: (p_base_table_name => 'BEN_ELIG_QUAL_TITL_PRTE_F',
18195: p_base_key_column => 'ELIG_QUAL_TITL_PRTE_ID',
18196: p_base_key_value => l_new_value,
18197: p_from_date => l_min_esd,
18699: fetch c_find_ESA_in_target into l_new_value ;
18700: if c_find_ESA_in_target%found then
18701: --
18702: --TEMPIK
18703: l_dt_rec_found := dt_api.check_min_max_dates
18704: (p_base_table_name => 'BEN_ELIG_SVC_AREA_PRTE_F',
18705: p_base_key_column => 'ELIG_SVC_AREA_PRTE_ID',
18706: p_base_key_value => l_new_value,
18707: p_from_date => l_min_esd,
19240: fetch c_find_ESH_in_target into l_new_value ;
19241: if c_find_ESH_in_target%found then
19242: --
19243: --TEMPIK
19244: l_dt_rec_found := dt_api.check_min_max_dates
19245: (p_base_table_name => 'BEN_ELIG_SCHEDD_HRS_PRTE_F',
19246: p_base_key_column => 'ELIG_SCHEDD_HRS_PRTE_ID',
19247: p_base_key_value => l_new_value,
19248: p_from_date => l_min_esd,
19772: fetch c_find_ESP_in_target into l_new_value ;
19773: if c_find_ESP_in_target%found then
19774: --
19775: --TEMPIK
19776: l_dt_rec_found := dt_api.check_min_max_dates
19777: (p_base_table_name => 'BEN_ELIG_SP_CLNG_PRG_PRTE_F',
19778: p_base_key_column => 'ELIG_SP_CLNG_PRG_PRTE_ID',
19779: p_base_key_value => l_new_value,
19780: p_from_date => l_min_esd,
20296: fetch c_find_EST_in_target into l_new_value ;
20297: if c_find_EST_in_target%found then
20298: --
20299: --TEMPIK
20300: l_dt_rec_found := dt_api.check_min_max_dates
20301: (p_base_table_name => 'BEN_ELIG_SUPPL_ROLE_PRTE_F',
20302: p_base_key_column => 'ELIG_SUPPL_ROLE_PRTE_ID',
20303: p_base_key_value => l_new_value,
20304: p_from_date => l_min_esd,
20810: fetch c_find_EWL_in_target into l_new_value ;
20811: if c_find_EWL_in_target%found then
20812: --
20813: --TEMPIK
20814: l_dt_rec_found := dt_api.check_min_max_dates
20815: (p_base_table_name => 'BEN_ELIG_WK_LOC_PRTE_F',
20816: p_base_key_column => 'ELIG_WK_LOC_PRTE_ID',
20817: p_base_key_value => l_new_value,
20818: p_from_date => l_min_esd,
21321: fetch c_find_ETD_in_target into l_new_value ;
21322: if c_find_ETD_in_target%found then
21323: --
21324: --TEMPIK
21325: l_dt_rec_found := dt_api.check_min_max_dates
21326: (p_base_table_name => 'BEN_ELIG_DPNT_OTHR_PTIP_F',
21327: p_base_key_column => 'ELIG_DPNT_OTHR_PTIP_ID',
21328: p_base_key_value => l_new_value,
21329: p_from_date => l_min_esd,
21825: fetch c_find_ECT_in_target into l_new_value ;
21826: if c_find_ECT_in_target%found then
21827: --
21828: --TEMPIK
21829: l_dt_rec_found := dt_api.check_min_max_dates
21830: (p_base_table_name => 'BEN_ELIG_DSBLTY_CTG_PRTE_F',
21831: p_base_key_column => 'ELIG_DSBLTY_CTG_PRTE_ID',
21832: p_base_key_value => l_new_value,
21833: p_from_date => l_min_esd,
22333: fetch c_find_EDD_in_target into l_new_value ;
22334: if c_find_EDD_in_target%found then
22335: --
22336: --TEMPIK
22337: l_dt_rec_found := dt_api.check_min_max_dates
22338: (p_base_table_name => 'BEN_ELIG_DSBLTY_DGR_PRTE_F',
22339: p_base_key_column => 'ELIG_DSBLTY_DGR_PRTE_ID',
22340: p_base_key_value => l_new_value,
22341: p_from_date => l_min_esd,
22861: if c_find_EDR_in_target%found then
22862:
22863: --
22864: --TEMPIK
22865: l_dt_rec_found := dt_api.check_min_max_dates
22866: (p_base_table_name => 'BEN_ELIG_DSBLTY_RSN_PRTE_F',
22867: p_base_key_column => 'ELIG_DSBLTY_RSN_PRTE_ID',
22868: p_base_key_value => l_new_value,
22869: p_from_date => l_min_esd,
23372: fetch c_find_EES_in_target into l_new_value ;
23373: if c_find_EES_in_target%found then
23374: --
23375: --TEMPIK
23376: l_dt_rec_found := dt_api.check_min_max_dates
23377: (p_base_table_name => 'BEN_ELIG_EE_STAT_PRTE_F',
23378: p_base_key_column => 'ELIG_EE_STAT_PRTE_ID',
23379: p_base_key_value => l_new_value,
23380: p_from_date => l_min_esd,
23873: fetch c_find_EEI_in_target into l_new_value ;
23874: if c_find_EEI_in_target%found then
23875: --
23876: --TEMPIK
23877: l_dt_rec_found := dt_api.check_min_max_dates
23878: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_OIPL_F',
23879: p_base_key_column => 'ELIG_ENRLD_ANTHR_OIPL_ID',
23880: p_base_key_value => l_new_value,
23881: p_from_date => l_min_esd,
24367: fetch c_find_EEG_in_target into l_new_value ;
24368: if c_find_EEG_in_target%found then
24369: --
24370: --TEMPIK
24371: l_dt_rec_found := dt_api.check_min_max_dates
24372: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PGM_F',
24373: p_base_key_column => 'ELIG_ENRLD_ANTHR_PGM_ID',
24374: p_base_key_value => l_new_value,
24375: p_from_date => l_min_esd,
24860: fetch c_find_EAI_in_target into l_new_value ;
24861: if c_find_EAI_in_target%found then
24862: --
24863: --TEMPIK
24864: l_dt_rec_found := dt_api.check_min_max_dates
24865: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PLIP_F',
24866: p_base_key_column => 'ELIG_ENRLD_ANTHR_PLIP_ID',
24867: p_base_key_value => l_new_value,
24868: p_from_date => l_min_esd,
25351: fetch c_find_EEP_in_target into l_new_value ;
25352: if c_find_EEP_in_target%found then
25353: --
25354: --TEMPIK
25355: l_dt_rec_found := dt_api.check_min_max_dates
25356: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PL_F',
25357: p_base_key_column => 'ELIG_ENRLD_ANTHR_PL_ID',
25358: p_base_key_value => l_new_value,
25359: p_from_date => l_min_esd,
25847: fetch c_find_EET_in_target into l_new_value ;
25848: if c_find_EET_in_target%found then
25849: --
25850: --TEMPIK
25851: l_dt_rec_found := dt_api.check_min_max_dates
25852: (p_base_table_name => 'BEN_ELIG_ENRLD_ANTHR_PTIP_F',
25853: p_base_key_column => 'ELIG_ENRLD_ANTHR_PTIP_ID',
25854: p_base_key_value => l_new_value,
25855: p_from_date => l_min_esd,
26349: fetch c_find_EFP_in_target into l_new_value ;
26350: if c_find_EFP_in_target%found then
26351: --
26352: --TEMPIK
26353: l_dt_rec_found := dt_api.check_min_max_dates
26354: (p_base_table_name => 'BEN_ELIG_FL_TM_PT_TM_PRTE_F',
26355: p_base_key_column => 'ELIG_FL_TM_PT_TM_PRTE_ID',
26356: p_base_key_value => l_new_value,
26357: p_from_date => l_min_esd,
26875: fetch c_find_EGR_in_target into l_new_value ;
26876: if c_find_EGR_in_target%found then
26877: --
26878: --TEMPIK
26879: l_dt_rec_found := dt_api.check_min_max_dates
26880: (p_base_table_name => 'BEN_ELIG_GRD_PRTE_F',
26881: p_base_key_column => 'ELIG_GRD_PRTE_ID',
26882: p_base_key_value => l_new_value,
26883: p_from_date => l_min_esd,
27380: fetch c_find_EHS_in_target into l_new_value ;
27381: if c_find_EHS_in_target%found then
27382: --
27383: --TEMPIK
27384: l_dt_rec_found := dt_api.check_min_max_dates
27385: (p_base_table_name => 'BEN_ELIG_HRLY_SLRD_PRTE_F',
27386: p_base_key_column => 'ELIG_HRLY_SLRD_PRTE_ID',
27387: p_base_key_value => l_new_value,
27388: p_from_date => l_min_esd,
27883: fetch c_find_ERG_in_target into l_new_value ;
27884: if c_find_ERG_in_target%found then
27885: --
27886: --TEMPIK
27887: l_dt_rec_found := dt_api.check_min_max_dates
27888: (p_base_table_name => 'BEN_ELIG_PERF_RTNG_PRTE_F',
27889: p_base_key_column => 'ELIG_PERF_RTNG_PRTE_ID',
27890: p_base_key_value => l_new_value,
27891: p_from_date => l_min_esd,
28382: fetch c_find_EQG_in_target into l_new_value ;
28383: if c_find_EQG_in_target%found then
28384: --
28385: --TEMPIK
28386: l_dt_rec_found := dt_api.check_min_max_dates
28387: (p_base_table_name => 'BEN_ELIG_QUA_IN_GR_PRTE_F',
28388: p_base_key_column => 'ELIG_QUA_IN_GR_PRTE_ID',
28389: p_base_key_value => l_new_value,
28390: p_from_date => l_min_esd,
28880: fetch c_find_EGN_in_target into l_new_value ;
28881: if c_find_EGN_in_target%found then
28882: --
28883: --TEMPIK
28884: l_dt_rec_found := dt_api.check_min_max_dates
28885: (p_base_table_name => 'BEN_ELIG_GNDR_PRTE_F',
28886: p_base_key_column => 'ELIG_GNDR_PRTE_ID',
28887: p_base_key_value => l_new_value,
28888: p_from_date => l_min_esd,
29371: fetch c_find_ETU_in_target into l_new_value ;
29372: if c_find_ETU_in_target%found then
29373: --
29374: --TEMPIK
29375: l_dt_rec_found := dt_api.check_min_max_dates
29376: (p_base_table_name => 'BEN_ELIG_TBCO_USE_PRTE_F',
29377: p_base_key_column => 'ELIG_TBCO_USE_PRTE_ID',
29378: p_base_key_value => l_new_value,
29379: p_from_date => l_min_esd,
29863: fetch c_find_EDB_in_target into l_new_value ;
29864: if c_find_EDB_in_target%found then
29865: --
29866: --TEMPIK
29867: l_dt_rec_found := dt_api.check_min_max_dates
29868: (p_base_table_name => 'BEN_ELIG_DSBLD_PRTE_F',
29869: p_base_key_column => 'ELIG_DSBLD_PRTE_ID',
29870: p_base_key_value => l_new_value,
29871: p_from_date => l_min_esd,
30387: fetch c_find_ETP_in_target into l_new_value ;
30388: if c_find_ETP_in_target%found then
30389: --
30390: --TEMPIK
30391: l_dt_rec_found := dt_api.check_min_max_dates
30392: (p_base_table_name => 'BEN_ELIG_TTL_PRTT_PRTE_F',
30393: p_base_key_column => 'ELIG_TTL_PRTT_PRTE_ID',
30394: p_base_key_value => l_new_value,
30395: p_from_date => l_min_esd,
30918: fetch c_find_ETC_in_target into l_new_value ;
30919: if c_find_ETC_in_target%found then
30920: --
30921: --TEMPIK
30922: l_dt_rec_found := dt_api.check_min_max_dates
30923: (p_base_table_name => 'BEN_ELIG_TTL_CVG_VOL_PRTE_F',
30924: p_base_key_column => 'ELIG_TTL_CVG_VOL_PRTE_ID',
30925: p_base_key_value => l_new_value,
30926: p_from_date => l_min_esd,
31431: fetch c_find_EHC_in_target into l_new_value ;
31432: if c_find_EHC_in_target%found then
31433: --
31434: --TEMPIK
31435: l_dt_rec_found := dt_api.check_min_max_dates
31436: (p_base_table_name => 'BEN_ELIG_HLTH_CVG_PRTE_F',
31437: p_base_key_column => 'ELIG_HLTH_CVG_PRTE_ID',
31438: p_base_key_value => l_new_value,
31439: p_from_date => l_min_esd,
31918: fetch c_find_EOP_in_target into l_new_value ;
31919: if c_find_EOP_in_target%found then
31920: --
31921: --TEMPIK
31922: l_dt_rec_found := dt_api.check_min_max_dates
31923: (p_base_table_name => 'BEN_ELIG_ANTHR_PL_PRTE_F',
31924: p_base_key_column => 'ELIG_ANTHR_PL_PRTE_ID',
31925: p_base_key_value => l_new_value,
31926: p_from_date => l_min_esd,
32686: IF c_find_ecv_in_target%FOUND
32687: THEN
32688: --
32689: l_dt_rec_found :=
32690: dt_api.check_min_max_dates (p_base_table_name => 'BEN_ELIGY_CRIT_VALUES_F',
32691: p_base_key_column => 'ELIGY_CRIT_VALUES_ID',
32692: p_base_key_value => l_new_value,
32693: p_from_date => l_min_esd,
32694: p_to_date => l_max_eed