APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_ACTY_BASE_RT_F

Line 104: from ben_acty_base_rt_f_efc efc

100: ,c_action_id number
101: )
102: is
103: select nvl(efc.pgm_uom,efc.nip_pl_uom)
104: from ben_acty_base_rt_f_efc efc
105: where efc.efc_action_id = c_action_id
106: and efc.acty_base_rt_id = c_abr_id
107: and efc.effective_start_date = c_esd;
108: --

Line 179: ben_acty_base_rt_f_efc efc

175: )
176: is
177: select nvl(efc.pgm_uom,efc.nip_pl_uom)
178: from ben_prtl_mo_rt_prtn_val_f ppv,
179: ben_acty_base_rt_f_efc efc
180: where efc.efc_action_id = c_action_id
181: and ppv.acty_base_rt_id = c_ppv_id
182: and efc.acty_base_rt_id = ppv.acty_base_rt_id
183: and c_esd

Line 231: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_ACTY_BASE_RT_F';

227: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';
228: l_ele_num := l_ele_num+1;
229: --
230: l_rndgtabnm_set.extend(1);
231: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_ACTY_BASE_RT_F';
232: l_rndgtabnm_set(l_ele_num).pkcol_name := 'ACTY_BASE_RT_ID';
233: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'RNDG_CD';
234: l_rndgtabnm_set(l_ele_num).ent_scode := 'ABR';
235: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';

Line 426: elsif l_rndgtab_name = 'BEN_ACTY_BASE_RT_F'

422: --
423: end if;
424: close c_get_apr_currcode;
425: --
426: elsif l_rndgtab_name = 'BEN_ACTY_BASE_RT_F'
427: then
428: --
429: open c_get_abr_currcode
430: (c_abr_id => l_rndgcodedets.id

Line 576: and l_rndgtab_name = 'BEN_ACTY_BASE_RT_F'

572: where actl_prem_id = l_rndgcodedets.id
573: and effective_start_date = l_rndgcodedets.effective_start_date;
574: --
575: elsif l_newrndg_code is not null
576: and l_rndgtab_name = 'BEN_ACTY_BASE_RT_F'
577: then
578: --
579: update ben_acty_base_rt_f
580: set rndg_cd = l_newrndg_code

Line 579: update ben_acty_base_rt_f

575: elsif l_newrndg_code is not null
576: and l_rndgtab_name = 'BEN_ACTY_BASE_RT_F'
577: then
578: --
579: update ben_acty_base_rt_f
580: set rndg_cd = l_newrndg_code
581: where acty_base_rt_id = l_rndgcodedets.id
582: and effective_start_date = l_rndgcodedets.effective_start_date;
583: --