[Home] [Help]
502: fetch c_find_CTU_in_target into l_new_value ;
503: if c_find_CTU_in_target%found then
504: --
505: --TEMPIK
506: l_dt_rec_found := dt_api.check_min_max_dates
507: (p_base_table_name => 'BEN_CM_TYP_USG_F',
508: p_base_key_column => 'CM_TYP_USG_ID',
509: p_base_key_value => l_new_value,
510: p_from_date => l_min_esd,
1006: fetch c_find_CTT_in_target into l_new_value ;
1007: if c_find_CTT_in_target%found then
1008: --
1009: --TEMPIK
1010: l_dt_rec_found := dt_api.check_min_max_dates
1011: (p_base_table_name => 'BEN_CM_TYP_TRGR_F',
1012: p_base_key_column => 'CM_TYP_TRGR_ID',
1013: p_base_key_value => l_new_value,
1014: p_from_date => l_min_esd,
2507: p_target_business_group_id, nvl(l_acty_base_rt_id, -999) ) ;
2508: fetch c_find_ABR_in_target into l_new_value ;
2509: if c_find_ABR_in_target%found then
2510: --TEMPIK
2511: l_dt_rec_found := dt_api.check_min_max_dates
2512: (p_base_table_name => 'BEN_ACTY_BASE_RT_F',
2513: p_base_key_column => 'ACTY_BASE_RT_ID',
2514: p_base_key_value => l_new_value,
2515: p_from_date => l_min_esd,
2547: p_target_business_group_id, nvl(l_acty_base_rt_id, -999) ) ;
2548: fetch c_find_ABR_name_in_target into l_new_value ;
2549: if c_find_ABR_name_in_target%found then
2550: --TEMPIK
2551: l_dt_rec_found := dt_api.check_min_max_dates
2552: (p_base_table_name => 'BEN_ACTY_BASE_RT_F',
2553: p_base_key_column => 'ACTY_BASE_RT_ID',
2554: p_base_key_value => l_new_value,
2555: p_from_date => l_min_esd,
3256: p_target_business_group_id, nvl(l_mtchg_rt_id, -999) ) ;
3257: fetch c_find_MTR_in_target into l_new_value ;
3258: if c_find_MTR_in_target%found then
3259: --TEMPIK
3260: l_dt_rec_found := dt_api.check_min_max_dates
3261: (p_base_table_name => 'BEN_MTCHG_RT_F',
3262: p_base_key_column => 'MTCHG_RT_ID',
3263: p_base_key_value => l_new_value,
3264: p_from_date => l_min_esd,
3766: p_target_business_group_id, nvl(l_acty_rt_ptd_lmt_id, -999) ) ;
3767: fetch c_find_APL1_in_target into l_new_value ;
3768: if c_find_APL1_in_target%found then
3769: --TEMPIK
3770: l_dt_rec_found := dt_api.check_min_max_dates
3771: (p_base_table_name => 'BEN_ACTY_RT_PTD_LMT_F',
3772: p_base_key_column => 'ACTY_RT_PTD_LMT_ID',
3773: p_base_key_value => l_new_value,
3774: p_from_date => l_min_esd,
4304: p_target_business_group_id, nvl(l_actl_prem_id, -999) ) ;
4305: fetch c_find_APR_in_target into l_new_value ;
4306: if c_find_APR_in_target%found then
4307: --TEMPIK
4308: l_dt_rec_found := dt_api.check_min_max_dates
4309: (p_base_table_name => 'BEN_ACTL_PREM_F',
4310: p_base_key_column => 'ACTL_PREM_ID',
4311: p_base_key_value => l_new_value,
4312: p_from_date => l_min_esd,
4343: fetch c_find_APR_name_in_target into l_new_value ;
4344: if c_find_APR_name_in_target%found then
4345: --
4346: --TEMPIK
4347: l_dt_rec_found := dt_api.check_min_max_dates
4348: (p_base_table_name => 'BEN_ACTL_PREM_F',
4349: p_base_key_column => 'ACTL_PREM_ID',
4350: p_base_key_value => l_new_value,
4351: p_from_date => l_min_esd,
4889: p_target_business_group_id, nvl(l_acty_vrbl_rt_id, -999) ) ;
4890: fetch c_find_AVR_in_target into l_new_value ;
4891: if c_find_AVR_in_target%found then
4892: --TEMPIK
4893: l_dt_rec_found := dt_api.check_min_max_dates
4894: (p_base_table_name => 'BEN_ACTY_VRBL_RT_F',
4895: p_base_key_column => 'ACTY_VRBL_RT_ID',
4896: p_base_key_value => l_new_value,
4897: p_from_date => l_min_esd,
5393: p_target_business_group_id, nvl(l_vrbl_rt_prfl_id, -999) ) ;
5394: fetch c_find_VPF_in_target into l_new_value ;
5395: if c_find_VPF_in_target%found then
5396: --TEMPIK
5397: l_dt_rec_found := dt_api.check_min_max_dates
5398: (p_base_table_name => 'BEN_VRBL_RT_PRFL_F',
5399: p_base_key_column => 'VRBL_RT_PRFL_ID',
5400: p_base_key_value => l_new_value,
5401: p_from_date => l_min_esd,
6106: p_target_business_group_id, nvl(l_cvg_amt_calc_mthd_id, -999) ) ;
6107: fetch c_find_CCM_in_target into l_new_value ;
6108: if c_find_CCM_in_target%found then
6109: --TEMPIK
6110: l_dt_rec_found := dt_api.check_min_max_dates
6111: (p_base_table_name => 'BEN_CVG_AMT_CALC_MTHD_F',
6112: p_base_key_column => 'CVG_AMT_CALC_MTHD_ID',
6113: p_base_key_value => l_new_value,
6114: p_from_date => l_min_esd,
6143: fetch c_find_CCM_name_in_target into l_new_value ;
6144: if c_find_CCM_name_in_target%found then
6145: --
6146: --TEMPIK
6147: l_dt_rec_found := dt_api.check_min_max_dates
6148: (p_base_table_name => 'BEN_CVG_AMT_CALC_MTHD_F',
6149: p_base_key_column => 'CVG_AMT_CALC_MTHD_ID',
6150: p_base_key_value => l_new_value,
6151: p_from_date => l_min_esd,
6673: fetch c_find_BVR1_in_target into l_new_value ;
6674: if c_find_BVR1_in_target%found then
6675: --
6676: --TEMPIK
6677: l_dt_rec_found := dt_api.check_min_max_dates
6678: (p_base_table_name => 'BEN_BNFT_VRBL_RT_F',
6679: p_base_key_column => 'BNFT_VRBL_RT_ID',
6680: p_base_key_value => l_new_value,
6681: p_from_date => l_min_esd,
7145: p_target_business_group_id, nvl(l_bnft_vrbl_rt_rl_id, -999) ) ;
7146: fetch c_find_BRR_in_target into l_new_value ;
7147: if c_find_BRR_in_target%found then
7148: --TEMPIK
7149: l_dt_rec_found := dt_api.check_min_max_dates
7150: (p_base_table_name => 'BEN_BNFT_VRBL_RT_RL_F',
7151: p_base_key_column => 'BNFT_VRBL_RT_RL_ID',
7152: p_base_key_value => l_new_value,
7153: p_from_date => l_min_esd,
7613: p_target_business_group_id, nvl(l_actl_prem_vrbl_rt_id, -999) ) ;
7614: fetch c_find_APV_in_target into l_new_value ;
7615: if c_find_APV_in_target%found then
7616: --TEMPIK
7617: l_dt_rec_found := dt_api.check_min_max_dates
7618: (p_base_table_name => 'BEN_ACTL_PREM_VRBL_RT_F',
7619: p_base_key_column => 'ACTL_PREM_VRBL_RT_ID',
7620: p_base_key_value => l_new_value,
7621: p_from_date => l_min_esd,
8094: fetch c_find_AVA_in_target into l_new_value ;
8095: if c_find_AVA_in_target%found then
8096: --
8097: --TEMPIK
8098: l_dt_rec_found := dt_api.check_min_max_dates
8099: (p_base_table_name => 'BEN_ACTL_PREM_VRBL_RT_RL_F',
8100: p_base_key_column => 'ACTL_PREM_VRBL_RT_RL_ID',
8101: p_base_key_value => l_new_value,
8102: p_from_date => l_min_esd,
8578: fetch c_find_ABP_in_target into l_new_value ;
8579: if c_find_ABP_in_target%found then
8580: --
8581: --TEMPIK
8582: l_dt_rec_found := dt_api.check_min_max_dates
8583: (p_base_table_name => 'BEN_APLCN_TO_BNFT_POOL_F',
8584: p_base_key_column => 'APLCN_TO_BNFT_POOL_ID',
8585: p_base_key_value => l_new_value,
8586: p_from_date => l_min_esd,
9066: fetch c_find_BPR_in_target into l_new_value ;
9067: if c_find_BPR_in_target%found then
9068: --
9069: --TEMPIK
9070: l_dt_rec_found := dt_api.check_min_max_dates
9071: (p_base_table_name => 'BEN_BNFT_POOL_RLOVR_RQMT_F',
9072: p_base_key_column => 'BNFT_POOL_RLOVR_RQMT_ID',
9073: p_base_key_value => l_new_value,
9074: p_from_date => l_min_esd,
9587: fetch c_find_DCR_in_target into l_new_value ;
9588: if c_find_DCR_in_target%found then
9589: --
9590: --TEMPIK
9591: l_dt_rec_found := dt_api.check_min_max_dates
9592: (p_base_table_name => 'BEN_DPNT_CVG_RQD_RLSHP_F',
9593: p_base_key_column => 'DPNT_CVG_RQD_RLSHP_ID',
9594: p_base_key_value => l_new_value,
9595: p_from_date => l_min_esd,
10069: fetch c_find_DEC_in_target into l_new_value ;
10070: if c_find_DEC_in_target%found then
10071: --
10072: --TEMPIK
10073: l_dt_rec_found := dt_api.check_min_max_dates
10074: (p_base_table_name => 'BEN_DSGNTR_ENRLD_CVG_F',
10075: p_base_key_column => 'DSGNTR_ENRLD_CVG_ID',
10076: p_base_key_value => l_new_value,
10077: p_from_date => l_min_esd,
10547: fetch c_find_DPC_in_target into l_new_value ;
10548: if c_find_DPC_in_target%found then
10549: --
10550: --TEMPIK
10551: l_dt_rec_found := dt_api.check_min_max_dates
10552: (p_base_table_name => 'BEN_DPNT_CVRD_ANTHR_PL_CVG_F',
10553: p_base_key_column => 'DPNT_CVRD_ANTHR_PL_CVG_ID',
10554: p_base_key_value => l_new_value,
10555: p_from_date => l_min_esd,
11032: fetch c_find_EAC_in_target into l_new_value ;
11033: if c_find_EAC_in_target%found then
11034: --
11035: --TEMPIK
11036: l_dt_rec_found := dt_api.check_min_max_dates
11037: (p_base_table_name => 'BEN_ELIG_AGE_CVG_F',
11038: p_base_key_column => 'ELIG_AGE_CVG_ID',
11039: p_base_key_value => l_new_value,
11040: p_from_date => l_min_esd,
11514: fetch c_find_EDC_in_target into l_new_value ;
11515: if c_find_EDC_in_target%found then
11516: --
11517: --TEMPIK
11518: l_dt_rec_found := dt_api.check_min_max_dates
11519: (p_base_table_name => 'BEN_ELIG_DSBLD_STAT_CVG_F',
11520: p_base_key_column => 'ELIG_DSBLD_STAT_CVG_ID',
11521: p_base_key_value => l_new_value,
11522: p_from_date => l_min_esd,
11997: p_target_business_group_id, nvl(l_elig_mltry_stat_cvg_id, -999) ) ;
11998: fetch c_find_EMC_in_target into l_new_value ;
11999: if c_find_EMC_in_target%found then
12000: --TEMPIK
12001: l_dt_rec_found := dt_api.check_min_max_dates
12002: (p_base_table_name => 'BEN_ELIG_MLTRY_STAT_CVG_F',
12003: p_base_key_column => 'ELIG_MLTRY_STAT_CVG_ID',
12004: p_base_key_value => l_new_value,
12005: p_from_date => l_min_esd,
12483: fetch c_find_EMS_in_target into l_new_value ;
12484: if c_find_EMS_in_target%found then
12485: --
12486: --TEMPIK
12487: l_dt_rec_found := dt_api.check_min_max_dates
12488: (p_base_table_name => 'BEN_ELIG_MRTL_STAT_CVG_F',
12489: p_base_key_column => 'ELIG_MRTL_STAT_CVG_ID',
12490: p_base_key_value => l_new_value,
12491: p_from_date => l_min_esd,
12954: p_target_business_group_id, nvl(l_elig_pstl_cd_r_rng_cvg_id, -999) ) ;
12955: fetch c_find_EPL_in_target into l_new_value ;
12956: if c_find_EPL_in_target%found then
12957: --TEMPIK
12958: l_dt_rec_found := dt_api.check_min_max_dates
12959: (p_base_table_name => 'BEN_ELIG_PSTL_CD_R_RNG_CVG_F',
12960: p_base_key_column => 'ELIG_PSTL_CD_R_RNG_CVG_ID',
12961: p_base_key_value => l_new_value,
12962: p_from_date => l_min_esd,
13435: p_target_business_group_id, nvl(l_elig_stdnt_stat_cvg_id, -999) ) ;
13436: fetch c_find_ESC_in_target into l_new_value ;
13437: if c_find_ESC_in_target%found then
13438: --TEMPIK
13439: l_dt_rec_found := dt_api.check_min_max_dates
13440: (p_base_table_name => 'BEN_ELIG_STDNT_STAT_CVG_F',
13441: p_base_key_column => 'ELIG_STDNT_STAT_CVG_ID',
13442: p_base_key_value => l_new_value,
13443: p_from_date => l_min_esd,
14708: p_target_business_group_id, nvl(l_acty_rt_pymt_sched_id, -999) ) ;
14709: fetch c_find_APF_in_target into l_new_value ;
14710: if c_find_APF_in_target%found then
14711: --TEMPIK
14712: l_dt_rec_found := dt_api.check_min_max_dates
14713: (p_base_table_name => 'BEN_ACTY_RT_PYMT_SCHED_F',
14714: p_base_key_column => 'ACTY_RT_PYMT_SCHED_ID',
14715: p_base_key_value => l_new_value,
14716: p_from_date => l_min_esd,
15189: p_target_business_group_id, nvl(l_acty_base_rt_ctfn_id, -999) ) ;
15190: fetch c_find_ABC_in_target into l_new_value ;
15191: if c_find_ABC_in_target%found then
15192: --TEMPIK
15193: l_dt_rec_found := dt_api.check_min_max_dates
15194: (p_base_table_name => 'BEN_ACTY_BASE_RT_CTFN_F',
15195: p_base_key_column => 'ACTY_BASE_RT_CTFN_ID',
15196: p_base_key_value => l_new_value,
15197: p_from_date => l_min_esd,
15700: p_target_business_group_id, nvl(l_prtl_mo_rt_prtn_val_id, -999) ) ;
15701: fetch c_find_PMRPV_in_target into l_new_value ;
15702: if c_find_PMRPV_in_target%found then
15703: --TEMPIK
15704: l_dt_rec_found := dt_api.check_min_max_dates
15705: (p_base_table_name => 'BEN_PRTL_MO_RT_PRTN_VAL_F',
15706: p_base_key_column => 'PRTL_MO_RT_PRTN_VAL_ID',
15707: p_base_key_value => l_new_value,
15708: p_from_date => l_min_esd,
16197: p_target_business_group_id, nvl(l_vrbl_rt_elig_prfl_id, -999) ) ;
16198: fetch c_find_VEP_in_target into l_new_value ;
16199: if c_find_VEP_in_target%found then
16200: --TEMPIK
16201: l_dt_rec_found := dt_api.check_min_max_dates
16202: (p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_F',
16203: p_base_key_column => 'VRBL_RT_ELIG_PRFL_ID',
16204: p_base_key_value => l_new_value,
16205: p_from_date => l_min_esd,