APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_POE_RT_F

Line 162: from ben_poe_rt_f prt,

158: ,c_action_id number
159: )
160: is
161: select nvl(efc.pgm_uom,efc.nip_pl_uom)
162: from ben_poe_rt_f prt,
163: ben_vrbl_rt_prfl_f_efc efc
164: where efc.efc_action_id = c_action_id
165: and prt.poe_rt_id = c_prt_id
166: and efc.vrbl_rt_prfl_id = prt.vrbl_rt_prfl_id

Line 271: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_POE_RT_F';

267: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';
268: l_ele_num := l_ele_num+1;
269: --
270: l_rndgtabnm_set.extend(1);
271: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_POE_RT_F';
272: l_rndgtabnm_set(l_ele_num).pkcol_name := 'POE_RT_ID';
273: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'RNDG_CD';
274: l_rndgtabnm_set(l_ele_num).ent_scode := 'PRT';
275: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';

Line 505: elsif l_rndgtab_name = 'BEN_POE_RT_F'

501: --
502: end if;
503: close c_get_ccm_currcode;
504: --
505: elsif l_rndgtab_name = 'BEN_POE_RT_F'
506: then
507: --
508: open c_get_prt_currcode
509: (c_prt_id => l_rndgcodedets.id

Line 620: and l_rndgtab_name = 'BEN_POE_RT_F'

616: where cvg_amt_calc_mthd_id = l_rndgcodedets.id
617: and effective_start_date = l_rndgcodedets.effective_start_date;
618: --
619: elsif l_newrndg_code is not null
620: and l_rndgtab_name = 'BEN_POE_RT_F'
621: then
622: --
623: update ben_poe_rt_f
624: set rndg_cd = l_newrndg_code

Line 623: update ben_poe_rt_f

619: elsif l_newrndg_code is not null
620: and l_rndgtab_name = 'BEN_POE_RT_F'
621: then
622: --
623: update ben_poe_rt_f
624: set rndg_cd = l_newrndg_code
625: where poe_rt_id = l_rndgcodedets.id
626: and effective_start_date = l_rndgcodedets.effective_start_date;
627: --