[Home] [Help]
431: fetch c_find_PRB_in_target into l_new_value ;
432: if c_find_PRB_in_target%found then
433: --
434: --TEMPIK
435: l_dt_rec_found := dt_api.check_min_max_dates
436: (p_base_table_name => 'BEN_PL_REGY_BOD_F',
437: p_base_key_column => 'PL_REGY_BOD_ID',
438: p_base_key_value => l_new_value,
439: p_from_date => l_min_esd,
903: fetch c_find_SAZ_in_target into l_new_value ;
904: if c_find_SAZ_in_target%found then
905: --
906: --TEMPIK
907: l_dt_rec_found := dt_api.check_min_max_dates
908: (p_base_table_name => 'BEN_SVC_AREA_PSTL_ZIP_RNG_F',
909: p_base_key_column => 'SVC_AREA_PSTL_ZIP_RNG_ID',
910: p_base_key_value => l_new_value,
911: p_from_date => l_min_esd,
1376: fetch c_find_PCX_in_target into l_new_value ;
1377: if c_find_PCX_in_target%found then
1378: --
1379: --TEMPIK
1380: l_dt_rec_found := dt_api.check_min_max_dates
1381: (p_base_table_name => 'BEN_PL_BNF_CTFN_F',
1382: p_base_key_column => 'PL_BNF_CTFN_ID',
1383: p_base_key_value => l_new_value,
1384: p_from_date => l_min_esd,
1855: fetch c_find_PND_in_target into l_new_value ;
1856: if c_find_PND_in_target%found then
1857: --
1858: --TEMPIK
1859: l_dt_rec_found := dt_api.check_min_max_dates
1860: (p_base_table_name => 'BEN_PL_DPNT_CVG_CTFN_F',
1861: p_base_key_column => 'PL_DPNT_CVG_CTFN_ID',
1862: p_base_key_value => l_new_value,
1863: p_from_date => l_min_esd,
2333: fetch c_find_LPE_in_target into l_new_value ;
2334: if c_find_LPE_in_target%found then
2335: --
2336: --TEMPIK
2337: l_dt_rec_found := dt_api.check_min_max_dates
2338: (p_base_table_name => 'BEN_LER_CHG_PL_NIP_ENRT_F',
2339: p_base_key_column => 'LER_CHG_PL_NIP_ENRT_ID',
2340: p_base_key_value => l_new_value,
2341: p_from_date => l_min_esd,
2818: fetch c_find_LOP_in_target into l_new_value ;
2819: if c_find_LOP_in_target%found then
2820: --
2821: --TEMPIK
2822: l_dt_rec_found := dt_api.check_min_max_dates
2823: (p_base_table_name => 'BEN_LER_CHG_OIPL_ENRT_F',
2824: p_base_key_column => 'LER_CHG_OIPL_ENRT_ID',
2825: p_base_key_value => l_new_value,
2826: p_from_date => l_min_esd,
3304: fetch c_find_LNC_in_target into l_new_value ;
3305: if c_find_LNC_in_target%found then
3306: --
3307: --TEMPIK
3308: l_dt_rec_found := dt_api.check_min_max_dates
3309: (p_base_table_name => 'BEN_LER_ENRT_CTFN_F',
3310: p_base_key_column => 'LER_ENRT_CTFN_ID',
3311: p_base_key_value => l_new_value,
3312: p_from_date => l_min_esd,
3781: fetch c_find_LRE_in_target into l_new_value ;
3782: if c_find_LRE_in_target%found then
3783: --
3784: --TEMPIK
3785: l_dt_rec_found := dt_api.check_min_max_dates
3786: (p_base_table_name => 'BEN_LER_RQRS_ENRT_CTFN_F',
3787: p_base_key_column => 'LER_RQRS_ENRT_CTFN_ID',
3788: p_base_key_value => l_new_value,
3789: p_from_date => l_min_esd,
4267: fetch c_find_LBC_in_target into l_new_value ;
4268: if c_find_LBC_in_target%found then
4269: --
4270: --TEMPIK
4271: l_dt_rec_found := dt_api.check_min_max_dates
4272: (p_base_table_name => 'BEN_LER_BNFT_RSTRN_CTFN_F',
4273: p_base_key_column => 'LER_BNFT_RSTRN_CTFN_ID',
4274: p_base_key_value => l_new_value,
4275: p_from_date => l_min_esd,
4736: fetch c_find_BRC_in_target into l_new_value ;
4737: if c_find_BRC_in_target%found then
4738: --
4739: --TEMPIK
4740: l_dt_rec_found := dt_api.check_min_max_dates
4741: (p_base_table_name => 'BEN_BNFT_RSTRN_CTFN_F',
4742: p_base_key_column => 'BNFT_RSTRN_CTFN_ID',
4743: p_base_key_value => l_new_value,
4744: p_from_date => l_min_esd,
5210: fetch c_find_WCN_in_target into l_new_value ;
5211: if c_find_WCN_in_target%found then
5212: --
5213: --TEMPIK
5214: l_dt_rec_found := dt_api.check_min_max_dates
5215: (p_base_table_name => 'BEN_WV_PRTN_RSN_CTFN_PL_F',
5216: p_base_key_column => 'WV_PRTN_RSN_CTFN_PL_ID',
5217: p_base_key_value => l_new_value,
5218: p_from_date => l_min_esd,
5686: fetch c_find_WPN_in_target into l_new_value ;
5687: if c_find_WPN_in_target%found then
5688: --
5689: --TEMPIK
5690: l_dt_rec_found := dt_api.check_min_max_dates
5691: (p_base_table_name => 'BEN_WV_PRTN_RSN_PL_F',
5692: p_base_key_column => 'WV_PRTN_RSN_PL_ID',
5693: p_base_key_value => l_new_value,
5694: p_from_date => l_min_esd,
6155: fetch c_find_VRP_in_target into l_new_value ;
6156: if c_find_VRP_in_target%found then
6157: --
6158: --TEMPIK
6159: l_dt_rec_found := dt_api.check_min_max_dates
6160: (p_base_table_name => 'BEN_VALD_RLSHP_FOR_REIMB_F',
6161: p_base_key_column => 'VALD_RLSHP_FOR_REIMB_ID',
6162: p_base_key_value => l_new_value,
6163: p_from_date => l_min_esd,
6625: fetch c_find_PCT_in_target into l_new_value ;
6626: if c_find_PCT_in_target%found then
6627: --
6628: --TEMPIK
6629: l_dt_rec_found := dt_api.check_min_max_dates
6630: (p_base_table_name => 'BEN_PL_GD_R_SVC_CTFN_F',
6631: p_base_key_column => 'PL_GD_R_SVC_CTFN_ID',
6632: p_base_key_value => l_new_value,
6633: p_from_date => l_min_esd,
7102: fetch c_find_VGS_in_target into l_new_value ;
7103: if c_find_VGS_in_target%found then
7104: --
7105: --TEMPIK
7106: l_dt_rec_found := dt_api.check_min_max_dates
7107: (p_base_table_name => 'BEN_PL_GD_OR_SVC_F',
7108: p_base_key_column => 'PL_GD_OR_SVC_ID',
7109: p_base_key_value => l_new_value,
7110: p_from_date => l_min_esd,
7590: fetch c_find_LBR_in_target into l_new_value ;
7591: if c_find_LBR_in_target%found then
7592: --
7593: --TEMPIK
7594: l_dt_rec_found := dt_api.check_min_max_dates
7595: (p_base_table_name => 'BEN_LER_BNFT_RSTRN_F',
7596: p_base_key_column => 'LER_BNFT_RSTRN_ID',
7597: p_base_key_value => l_new_value,
7598: p_from_date => l_min_esd,
8105: fetch c_find_LPR1_in_target into l_new_value ;
8106: if c_find_LPR1_in_target%found then
8107: --
8108: --TEMPIK
8109: l_dt_rec_found := dt_api.check_min_max_dates
8110: (p_base_table_name => 'BEN_LER_CHG_PLIP_ENRT_F',
8111: p_base_key_column => 'LER_CHG_PLIP_ENRT_ID',
8112: p_base_key_value => l_new_value,
8113: p_from_date => l_min_esd,
8621: fetch c_find_CPP_in_target into l_new_value ;
8622: if c_find_CPP_in_target%found then
8623: --
8624: --TEMPIK
8625: l_dt_rec_found := dt_api.check_min_max_dates
8626: (p_base_table_name => 'BEN_PLIP_F',
8627: p_base_key_column => 'PLIP_ID',
8628: p_base_key_value => l_new_value,
8629: p_from_date => l_min_esd,
9205: fetch c_find_PYD_in_target into l_new_value ;
9206: if c_find_PYD_in_target%found then
9207: --
9208: --TEMPIK
9209: l_dt_rec_found := dt_api.check_min_max_dates
9210: (p_base_table_name => 'BEN_PTIP_DPNT_CVG_CTFN_F',
9211: p_base_key_column => 'PTIP_DPNT_CVG_CTFN_ID',
9212: p_base_key_value => l_new_value,
9213: p_from_date => l_min_esd,
9691: fetch c_find_LCT_in_target into l_new_value ;
9692: if c_find_LCT_in_target%found then
9693: --
9694: --TEMPIK
9695: l_dt_rec_found := dt_api.check_min_max_dates
9696: (p_base_table_name => 'BEN_LER_CHG_PTIP_ENRT_F',
9697: p_base_key_column => 'LER_CHG_PTIP_ENRT_ID',
9698: p_base_key_value => l_new_value,
9699: p_from_date => l_min_esd,
10178: fetch c_find_WCT_in_target into l_new_value ;
10179: if c_find_WCT_in_target%found then
10180: --
10181: --TEMPIK
10182: l_dt_rec_found := dt_api.check_min_max_dates
10183: (p_base_table_name => 'BEN_WV_PRTN_RSN_CTFN_PTIP_F',
10184: p_base_key_column => 'WV_PRTN_RSN_CTFN_PTIP_ID',
10185: p_base_key_value => l_new_value,
10186: p_from_date => l_min_esd,
10656: fetch c_find_WPT_in_target into l_new_value ;
10657: if c_find_WPT_in_target%found then
10658: --
10659: --TEMPIK
10660: l_dt_rec_found := dt_api.check_min_max_dates
10661: (p_base_table_name => 'BEN_WV_PRTN_RSN_PTIP_F',
10662: p_base_key_column => 'WV_PRTN_RSN_PTIP_ID',
10663: p_base_key_value => l_new_value,
10664: p_from_date => l_min_esd,
11169: fetch c_find_CTP_in_target into l_new_value ;
11170: if c_find_CTP_in_target%found then
11171: --
11172: --TEMPIK
11173: l_dt_rec_found := dt_api.check_min_max_dates
11174: (p_base_table_name => 'BEN_PTIP_F',
11175: p_base_key_column => 'PTIP_ID',
11176: p_base_key_value => l_new_value,
11177: p_from_date => l_min_esd,
11786: fetch c_find_LCC_in_target into l_new_value ;
11787: if c_find_LCC_in_target%found then
11788: --
11789: --TEMPIK
11790: l_dt_rec_found := dt_api.check_min_max_dates
11791: (p_base_table_name => 'BEN_LER_CHG_DPNT_CVG_CTFN_F',
11792: p_base_key_column => 'LER_CHG_DPNT_CVG_CTFN_ID',
11793: p_base_key_value => l_new_value,
11794: p_from_date => l_min_esd,
12261: fetch c_find_CER_in_target into l_new_value ;
12262: if c_find_CER_in_target%found then
12263: --
12264: --TEMPIK
12265: l_dt_rec_found := dt_api.check_min_max_dates
12266: (p_base_table_name => 'BEN_PRTN_ELIGY_RL_F',
12267: p_base_key_column => 'PRTN_ELIGY_RL_ID',
12268: p_base_key_value => l_new_value,
12269: p_from_date => l_min_esd,
12732: fetch c_find_CEP_in_target into l_new_value ;
12733: if c_find_CEP_in_target%found then
12734: --
12735: --TEMPIK
12736: l_dt_rec_found := dt_api.check_min_max_dates
12737: (p_base_table_name => 'BEN_PRTN_ELIG_PRFL_F',
12738: p_base_key_column => 'PRTN_ELIG_PRFL_ID',
12739: p_base_key_value => l_new_value,
12740: p_from_date => l_min_esd,
13212: fetch c_find_CPR_in_target into l_new_value ;
13213: if c_find_CPR_in_target%found then
13214: --
13215: --TEMPIK
13216: l_dt_rec_found := dt_api.check_min_max_dates
13217: (p_base_table_name => 'BEN_POPL_ORG_ROLE_F',
13218: p_base_key_column => 'POPL_ORG_ROLE_ID',
13219: p_base_key_value => l_new_value,
13220: p_from_date => l_min_esd,
13723: fetch c_find_CPO_in_target into l_new_value ;
13724: if c_find_CPO_in_target%found then
13725: --
13726: --TEMPIK
13727: l_dt_rec_found := dt_api.check_min_max_dates
13728: (p_base_table_name => 'BEN_POPL_ORG_F',
13729: p_base_key_column => 'POPL_ORG_ID',
13730: p_base_key_value => l_new_value,
13731: p_from_date => l_min_esd,
14250: fetch c_find_PRG_in_target into l_new_value ;
14251: if c_find_PRG_in_target%found then
14252: --
14253: --TEMPIK
14254: l_dt_rec_found := dt_api.check_min_max_dates
14255: (p_base_table_name => 'BEN_PL_REGN_F',
14256: p_base_key_column => 'PL_REGN_ID',
14257: p_base_key_value => l_new_value,
14258: p_from_date => l_min_esd,
14740: fetch c_find_RGR_in_target into l_new_value ;
14741: if c_find_RGR_in_target%found then
14742: --
14743: --TEMPIK
14744: l_dt_rec_found := dt_api.check_min_max_dates
14745: (p_base_table_name => 'BEN_POPL_RPTG_GRP_F',
14746: p_base_key_column => 'POPL_RPTG_GRP_ID',
14747: p_base_key_value => l_new_value,
14748: p_from_date => l_min_esd,
15217: fetch c_find_ECF_in_target into l_new_value ;
15218: if c_find_ECF_in_target%found then
15219: --
15220: --TEMPIK
15221: l_dt_rec_found := dt_api.check_min_max_dates
15222: (p_base_table_name => 'BEN_ENRT_CTFN_F',
15223: p_base_key_column => 'ENRT_CTFN_ID',
15224: p_base_key_value => l_new_value,
15225: p_from_date => l_min_esd,
15713: fetch c_find_EPA_in_target into l_new_value ;
15714: if c_find_EPA_in_target%found then
15715: --
15716: --TEMPIK
15717: l_dt_rec_found := dt_api.check_min_max_dates
15718: (p_base_table_name => 'BEN_PRTN_ELIG_F',
15719: p_base_key_column => 'PRTN_ELIG_ID',
15720: p_base_key_value => l_new_value,
15721: p_from_date => l_min_esd,
16564: fetch c_find_PET_in_target into l_new_value ;
16565: if c_find_PET_in_target%found then
16566: --
16567: --TEMPIK
16568: l_dt_rec_found := dt_api.check_min_max_dates
16569: (p_base_table_name => 'BEN_POPL_ENRT_TYP_CYCL_F',
16570: p_base_key_column => 'POPL_ENRT_TYP_CYCL_ID',
16571: p_base_key_value => l_new_value,
16572: p_from_date => l_min_esd,
17506: fetch c_find_LEN_in_target into l_new_value ;
17507: if c_find_LEN_in_target%found then
17508: --
17509: --TEMPIK
17510: l_dt_rec_found := dt_api.check_min_max_dates
17511: (p_base_table_name => 'BEN_LEE_RSN_F',
17512: p_base_key_column => 'LEE_RSN_ID',
17513: p_base_key_value => l_new_value,
17514: p_from_date => l_min_esd,
18032: fetch c_find_ERP_in_target into l_new_value ;
18033: if c_find_ERP_in_target%found then
18034: --
18035: --TEMPIK
18036: l_dt_rec_found := dt_api.check_min_max_dates
18037: (p_base_table_name => 'BEN_ENRT_PERD_FOR_PL_F',
18038: p_base_key_column => 'ENRT_PERD_FOR_PL_ID',
18039: p_base_key_value => l_new_value,
18040: p_from_date => l_min_esd,
18512: fetch c_find_SER_in_target into l_new_value ;
18513: if c_find_SER_in_target%found then
18514: --
18515: --TEMPIK
18516: l_dt_rec_found := dt_api.check_min_max_dates
18517: (p_base_table_name => 'BEN_SCHEDD_ENRT_RL_F',
18518: p_base_key_column => 'SCHEDD_ENRT_RL_ID',
18519: p_base_key_value => l_new_value,
18520: p_from_date => l_min_esd,
18975: fetch c_find_LRR_in_target into l_new_value ;
18976: if c_find_LRR_in_target%found then
18977: --
18978: --TEMPIK
18979: l_dt_rec_found := dt_api.check_min_max_dates
18980: (p_base_table_name => 'BEN_LEE_RSN_RL_F',
18981: p_base_key_column => 'LEE_RSN_RL_ID',
18982: p_base_key_value => l_new_value,
18983: p_from_date => l_min_esd,
19449: fetch c_find_ADE_in_target into l_new_value ;
19450: if c_find_ADE_in_target%found then
19451: --
19452: --TEMPIK
19453: l_dt_rec_found := dt_api.check_min_max_dates
19454: (p_base_table_name => 'BEN_APLD_DPNT_CVG_ELIG_PRFL_F',
19455: p_base_key_column => 'APLD_DPNT_CVG_ELIG_PRFL_ID',
19456: p_base_key_value => l_new_value,
19457: p_from_date => l_min_esd,
19921: fetch c_find_PGC_in_target into l_new_value ;
19922: if c_find_PGC_in_target%found then
19923: --
19924: --TEMPIK
19925: l_dt_rec_found := dt_api.check_min_max_dates
19926: (p_base_table_name => 'BEN_PGM_DPNT_CVG_CTFN_F',
19927: p_base_key_column => 'PGM_DPNT_CVG_CTFN_ID',
19928: p_base_key_value => l_new_value,
19929: p_from_date => l_min_esd,
20399: p_target_business_group_id, nvl(l_ler_chg_pgm_enrt_id, -999) ) ;
20400: fetch c_find_LGE_in_target into l_new_value ;
20401: if c_find_LGE_in_target%found then
20402: --TEMPIK
20403: l_dt_rec_found := dt_api.check_min_max_dates
20404: (p_base_table_name => 'BEN_LER_CHG_PGM_ENRT_F',
20405: p_base_key_column => 'LER_CHG_PGM_ENRT_ID',
20406: p_base_key_value => l_new_value,
20407: p_from_date => l_min_esd,
20897: fetch c_find_LDC_in_target into l_new_value ;
20898: if c_find_LDC_in_target%found then
20899: --
20900: --TEMPIK
20901: l_dt_rec_found := dt_api.check_min_max_dates
20902: (p_base_table_name => 'BEN_LER_CHG_DPNT_CVG_F',
20903: p_base_key_column => 'LER_CHG_DPNT_CVG_ID',
20904: p_base_key_value => l_new_value,
20905: p_from_date => l_min_esd,
21392: fetch c_find_PAT_in_target into l_new_value ;
21393: if c_find_PAT_in_target%found then
21394: --
21395: --TEMPIK
21396: l_dt_rec_found := dt_api.check_min_max_dates
21397: (p_base_table_name => 'BEN_POPL_ACTN_TYP_F',
21398: p_base_key_column => 'POPL_ACTN_TYP_ID',
21399: p_base_key_value => l_new_value,
21400: p_from_date => l_min_esd,
21903: fetch c_find_PEO_in_target into l_new_value ;
21904: if c_find_PEO_in_target%found then
21905: --
21906: --TEMPIK
21907: l_dt_rec_found := dt_api.check_min_max_dates
21908: (p_base_table_name => 'BEN_ELIG_TO_PRTE_RSN_F',
21909: p_base_key_column => 'ELIG_TO_PRTE_RSN_ID',
21910: p_base_key_value => l_new_value,
21911: p_from_date => l_min_esd,
23362: fetch c_find_COP_in_target into l_new_value ;
23363: if c_find_COP_in_target%found then
23364: --
23365: --TEMPIK
23366: l_dt_rec_found := dt_api.check_min_max_dates
23367: (p_base_table_name => 'BEN_OIPL_F',
23368: p_base_key_column => 'OIPL_ID',
23369: p_base_key_value => l_new_value,
23370: p_from_date => l_min_esd,
23909: fetch c_find_DDR_in_target into l_new_value ;
23910: if c_find_DDR_in_target%found then
23911: --
23912: --TEMPIK
23913: l_dt_rec_found := dt_api.check_min_max_dates
23914: (p_base_table_name => 'BEN_DSGN_RQMT_F',
23915: p_base_key_column => 'DSGN_RQMT_ID',
23916: p_base_key_value => l_new_value,
23917: p_from_date => l_min_esd,
24688: fetch c_find_OPP_in_target into l_new_value ;
24689: if c_find_OPP_in_target%found then
24690: --
24691: --TEMPIK
24692: l_dt_rec_found := dt_api.check_min_max_dates
24693: (p_base_table_name => 'BEN_OIPLIP_F',
24694: p_base_key_column => 'OIPLIP_ID',
24695: p_base_key_value => l_new_value,
24696: p_from_date => l_min_esd,
25085: fetch c_find_OTP_in_target into l_new_value ;
25086: if c_find_OTP_in_target%found then
25087: --
25088: --TEMPIK
25089: l_dt_rec_found := dt_api.check_min_max_dates
25090: (p_base_table_name => 'BEN_OPTIP_F',
25091: p_base_key_column => 'OPTIP_ID',
25092: p_base_key_value => l_new_value,
25093: p_from_date => l_min_esd,
25899: fetch c_find_PRP_in_target into l_new_value ;
25900: if c_find_PRP_in_target%found then
25901: --
25902: --TEMPIK
25903: l_dt_rec_found := dt_api.check_min_max_dates
25904: (p_base_table_name => 'BEN_PL_REGY_PRPS_F',
25905: p_base_key_column => 'PL_REGY_PRPS_ID',
25906: p_base_key_value => l_new_value,
25907: p_from_date => l_min_esd,
26430: fetch c_find_BPP_in_target into l_new_value ;
26431: if c_find_BPP_in_target%found then
26432: --
26433: --TEMPIK
26434: l_dt_rec_found := dt_api.check_min_max_dates
26435: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
26436: p_base_key_column => 'BNFT_PRVDR_POOL_ID',
26437: p_base_key_value => l_new_value,
26438: p_from_date => l_min_esd,
26470: fetch c_find_BPP_name_in_target into l_new_value ;
26471: if c_find_BPP_name_in_target%found then
26472: --
26473: --TEMPIK
26474: l_dt_rec_found := dt_api.check_min_max_dates
26475: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
26476: p_base_key_column => 'BNFT_PRVDR_POOL_ID',
26477: p_base_key_value => l_new_value,
26478: p_from_date => l_min_esd,
26998: fetch c_find_ACP_in_target into l_new_value ;
26999: if c_find_ACP_in_target%found then
27000: --
27001: --TEMPIK
27002: l_dt_rec_found := dt_api.check_min_max_dates
27003: (p_base_table_name => 'BEN_ACRS_PTIP_CVG_F',
27004: p_base_key_column => 'ACRS_PTIP_CVG_ID',
27005: p_base_key_value => l_new_value,
27006: p_from_date => l_min_esd,