APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_PRTL_MO_RT_PRTN_VAL_F

Line 178: from ben_prtl_mo_rt_prtn_val_f ppv,

174: ,c_action_id number
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

Line 279: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_PRTL_MO_RT_PRTN_VAL_F';

275: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';
276: l_ele_num := l_ele_num+1;
277: --
278: l_rndgtabnm_set.extend(1);
279: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_PRTL_MO_RT_PRTN_VAL_F';
280: l_rndgtabnm_set(l_ele_num).pkcol_name := 'PRTL_MO_RT_PRTN_VAL_ID';
281: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'RNDG_CD';
282: l_rndgtabnm_set(l_ele_num).ent_scode := 'PMRPV';
283: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';

Line 521: elsif l_rndgtab_name = 'BEN_PRTL_MO_RT_PRTN_VAL_F'

517: --
518: end if;
519: close c_get_prt_currcode;
520: --
521: elsif l_rndgtab_name = 'BEN_PRTL_MO_RT_PRTN_VAL_F'
522: then
523: --
524: open c_get_ppv_currcode
525: (c_ppv_id => l_rndgcodedets.id

Line 629: and l_rndgtab_name = 'BEN_PRTL_MO_RT_PRTN_VAL_F'

625: where poe_rt_id = l_rndgcodedets.id
626: and effective_start_date = l_rndgcodedets.effective_start_date;
627: --
628: elsif l_newrndg_code is not null
629: and l_rndgtab_name = 'BEN_PRTL_MO_RT_PRTN_VAL_F'
630: then
631: --
632: update ben_prtl_mo_rt_prtn_val_f
633: set rndg_cd = l_newrndg_code

Line 632: update ben_prtl_mo_rt_prtn_val_f

628: elsif l_newrndg_code is not null
629: and l_rndgtab_name = 'BEN_PRTL_MO_RT_PRTN_VAL_F'
630: then
631: --
632: update ben_prtl_mo_rt_prtn_val_f
633: set rndg_cd = l_newrndg_code
634: where prtl_mo_rt_prtn_val_id = l_rndgcodedets.id
635: and effective_start_date = l_rndgcodedets.effective_start_date;
636: --