[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,
16651: fetch c_find_PET_in_target into l_new_value ;
16652: if c_find_PET_in_target%found then
16653: --
16654: --TEMPIK
16655: l_dt_rec_found := dt_api.check_min_max_dates
16656: (p_base_table_name => 'BEN_POPL_ENRT_TYP_CYCL_F',
16657: p_base_key_column => 'POPL_ENRT_TYP_CYCL_ID',
16658: p_base_key_value => l_new_value,
16659: p_from_date => l_min_esd,
17593: fetch c_find_LEN_in_target into l_new_value ;
17594: if c_find_LEN_in_target%found then
17595: --
17596: --TEMPIK
17597: l_dt_rec_found := dt_api.check_min_max_dates
17598: (p_base_table_name => 'BEN_LEE_RSN_F',
17599: p_base_key_column => 'LEE_RSN_ID',
17600: p_base_key_value => l_new_value,
17601: p_from_date => l_min_esd,
18119: fetch c_find_ERP_in_target into l_new_value ;
18120: if c_find_ERP_in_target%found then
18121: --
18122: --TEMPIK
18123: l_dt_rec_found := dt_api.check_min_max_dates
18124: (p_base_table_name => 'BEN_ENRT_PERD_FOR_PL_F',
18125: p_base_key_column => 'ENRT_PERD_FOR_PL_ID',
18126: p_base_key_value => l_new_value,
18127: p_from_date => l_min_esd,
18599: fetch c_find_SER_in_target into l_new_value ;
18600: if c_find_SER_in_target%found then
18601: --
18602: --TEMPIK
18603: l_dt_rec_found := dt_api.check_min_max_dates
18604: (p_base_table_name => 'BEN_SCHEDD_ENRT_RL_F',
18605: p_base_key_column => 'SCHEDD_ENRT_RL_ID',
18606: p_base_key_value => l_new_value,
18607: p_from_date => l_min_esd,
19062: fetch c_find_LRR_in_target into l_new_value ;
19063: if c_find_LRR_in_target%found then
19064: --
19065: --TEMPIK
19066: l_dt_rec_found := dt_api.check_min_max_dates
19067: (p_base_table_name => 'BEN_LEE_RSN_RL_F',
19068: p_base_key_column => 'LEE_RSN_RL_ID',
19069: p_base_key_value => l_new_value,
19070: p_from_date => l_min_esd,
19536: fetch c_find_ADE_in_target into l_new_value ;
19537: if c_find_ADE_in_target%found then
19538: --
19539: --TEMPIK
19540: l_dt_rec_found := dt_api.check_min_max_dates
19541: (p_base_table_name => 'BEN_APLD_DPNT_CVG_ELIG_PRFL_F',
19542: p_base_key_column => 'APLD_DPNT_CVG_ELIG_PRFL_ID',
19543: p_base_key_value => l_new_value,
19544: p_from_date => l_min_esd,
20008: fetch c_find_PGC_in_target into l_new_value ;
20009: if c_find_PGC_in_target%found then
20010: --
20011: --TEMPIK
20012: l_dt_rec_found := dt_api.check_min_max_dates
20013: (p_base_table_name => 'BEN_PGM_DPNT_CVG_CTFN_F',
20014: p_base_key_column => 'PGM_DPNT_CVG_CTFN_ID',
20015: p_base_key_value => l_new_value,
20016: p_from_date => l_min_esd,
20486: p_target_business_group_id, nvl(l_ler_chg_pgm_enrt_id, -999) ) ;
20487: fetch c_find_LGE_in_target into l_new_value ;
20488: if c_find_LGE_in_target%found then
20489: --TEMPIK
20490: l_dt_rec_found := dt_api.check_min_max_dates
20491: (p_base_table_name => 'BEN_LER_CHG_PGM_ENRT_F',
20492: p_base_key_column => 'LER_CHG_PGM_ENRT_ID',
20493: p_base_key_value => l_new_value,
20494: p_from_date => l_min_esd,
20984: fetch c_find_LDC_in_target into l_new_value ;
20985: if c_find_LDC_in_target%found then
20986: --
20987: --TEMPIK
20988: l_dt_rec_found := dt_api.check_min_max_dates
20989: (p_base_table_name => 'BEN_LER_CHG_DPNT_CVG_F',
20990: p_base_key_column => 'LER_CHG_DPNT_CVG_ID',
20991: p_base_key_value => l_new_value,
20992: p_from_date => l_min_esd,
21479: fetch c_find_PAT_in_target into l_new_value ;
21480: if c_find_PAT_in_target%found then
21481: --
21482: --TEMPIK
21483: l_dt_rec_found := dt_api.check_min_max_dates
21484: (p_base_table_name => 'BEN_POPL_ACTN_TYP_F',
21485: p_base_key_column => 'POPL_ACTN_TYP_ID',
21486: p_base_key_value => l_new_value,
21487: p_from_date => l_min_esd,
21990: fetch c_find_PEO_in_target into l_new_value ;
21991: if c_find_PEO_in_target%found then
21992: --
21993: --TEMPIK
21994: l_dt_rec_found := dt_api.check_min_max_dates
21995: (p_base_table_name => 'BEN_ELIG_TO_PRTE_RSN_F',
21996: p_base_key_column => 'ELIG_TO_PRTE_RSN_ID',
21997: p_base_key_value => l_new_value,
21998: p_from_date => l_min_esd,
23464: fetch c_find_COP_in_target into l_new_value ;
23465: if c_find_COP_in_target%found then
23466: --
23467: --TEMPIK
23468: l_dt_rec_found := dt_api.check_min_max_dates
23469: (p_base_table_name => 'BEN_OIPL_F',
23470: p_base_key_column => 'OIPL_ID',
23471: p_base_key_value => l_new_value,
23472: p_from_date => l_min_esd,
24011: fetch c_find_DDR_in_target into l_new_value ;
24012: if c_find_DDR_in_target%found then
24013: --
24014: --TEMPIK
24015: l_dt_rec_found := dt_api.check_min_max_dates
24016: (p_base_table_name => 'BEN_DSGN_RQMT_F',
24017: p_base_key_column => 'DSGN_RQMT_ID',
24018: p_base_key_value => l_new_value,
24019: p_from_date => l_min_esd,
24790: fetch c_find_OPP_in_target into l_new_value ;
24791: if c_find_OPP_in_target%found then
24792: --
24793: --TEMPIK
24794: l_dt_rec_found := dt_api.check_min_max_dates
24795: (p_base_table_name => 'BEN_OIPLIP_F',
24796: p_base_key_column => 'OIPLIP_ID',
24797: p_base_key_value => l_new_value,
24798: p_from_date => l_min_esd,
25187: fetch c_find_OTP_in_target into l_new_value ;
25188: if c_find_OTP_in_target%found then
25189: --
25190: --TEMPIK
25191: l_dt_rec_found := dt_api.check_min_max_dates
25192: (p_base_table_name => 'BEN_OPTIP_F',
25193: p_base_key_column => 'OPTIP_ID',
25194: p_base_key_value => l_new_value,
25195: p_from_date => l_min_esd,
26001: fetch c_find_PRP_in_target into l_new_value ;
26002: if c_find_PRP_in_target%found then
26003: --
26004: --TEMPIK
26005: l_dt_rec_found := dt_api.check_min_max_dates
26006: (p_base_table_name => 'BEN_PL_REGY_PRP_F', --bug 12558413
26007: p_base_key_column => 'PL_REGY_PRPS_ID',
26008: p_base_key_value => l_new_value,
26009: p_from_date => l_min_esd,
26532: fetch c_find_BPP_in_target into l_new_value ;
26533: if c_find_BPP_in_target%found then
26534: --
26535: --TEMPIK
26536: l_dt_rec_found := dt_api.check_min_max_dates
26537: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
26538: p_base_key_column => 'BNFT_PRVDR_POOL_ID',
26539: p_base_key_value => l_new_value,
26540: p_from_date => l_min_esd,
26572: fetch c_find_BPP_name_in_target into l_new_value ;
26573: if c_find_BPP_name_in_target%found then
26574: --
26575: --TEMPIK
26576: l_dt_rec_found := dt_api.check_min_max_dates
26577: (p_base_table_name => 'BEN_BNFT_PRVDR_POOL_F',
26578: p_base_key_column => 'BNFT_PRVDR_POOL_ID',
26579: p_base_key_value => l_new_value,
26580: p_from_date => l_min_esd,
27100: fetch c_find_ACP_in_target into l_new_value ;
27101: if c_find_ACP_in_target%found then
27102: --
27103: --TEMPIK
27104: l_dt_rec_found := dt_api.check_min_max_dates
27105: (p_base_table_name => 'BEN_ACRS_PTIP_CVG_F',
27106: p_base_key_column => 'ACRS_PTIP_CVG_ID',
27107: p_base_key_value => l_new_value,
27108: p_from_date => l_min_esd,