APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_BNFT_POOL_RLOVR_RQMT_F

Line 116: from ben_bnft_pool_rlovr_rqmt_f_efc efc

112: ,c_action_id number
113: )
114: is
115: select nvl(efc.pgm_uom,efc.nip_pl_uom)
116: from ben_bnft_pool_rlovr_rqmt_f_efc efc
117: where efc.efc_action_id = c_action_id
118: and efc.bnft_pool_rlovr_rqmt_id = c_bpr_id
119: and efc.effective_start_date = c_esd;
120: --

Line 239: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_BNFT_POOL_RLOVR_RQMT_F';

235: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';
236: l_ele_num := l_ele_num+1;
237: --
238: l_rndgtabnm_set.extend(1);
239: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_BNFT_POOL_RLOVR_RQMT_F';
240: l_rndgtabnm_set(l_ele_num).pkcol_name := 'BNFT_POOL_RLOVR_RQMT_ID';
241: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'VAL_RNDG_CD';
242: l_rndgtabnm_set(l_ele_num).ent_scode := 'BPR';
243: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';

Line 442: elsif l_rndgtab_name = 'BEN_BNFT_POOL_RLOVR_RQMT_F'

438: --
439: end if;
440: close c_get_abr_currcode;
441: --
442: elsif l_rndgtab_name = 'BEN_BNFT_POOL_RLOVR_RQMT_F'
443: then
444: --
445: open c_get_bpr_currcode
446: (c_bpr_id => l_rndgcodedets.id

Line 585: and l_rndgtab_name = 'BEN_BNFT_POOL_RLOVR_RQMT_F'

581: where acty_base_rt_id = l_rndgcodedets.id
582: and effective_start_date = l_rndgcodedets.effective_start_date;
583: --
584: elsif l_newrndg_code is not null
585: and l_rndgtab_name = 'BEN_BNFT_POOL_RLOVR_RQMT_F'
586: then
587: --
588: update ben_bnft_pool_rlovr_rqmt_f
589: set val_rndg_cd = l_newrndg_code

Line 588: update ben_bnft_pool_rlovr_rqmt_f

584: elsif l_newrndg_code is not null
585: and l_rndgtab_name = 'BEN_BNFT_POOL_RLOVR_RQMT_F'
586: then
587: --
588: update ben_bnft_pool_rlovr_rqmt_f
589: set val_rndg_cd = l_newrndg_code
590: where bnft_pool_rlovr_rqmt_id = l_rndgcodedets.id
591: and effective_start_date = l_rndgcodedets.effective_start_date;
592: --