APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_VRBL_RT_PRFL_F

Line 163: ben_vrbl_rt_prfl_f_efc efc

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
167: and c_esd

Line 194: from ben_vrbl_rt_prfl_f_efc efc

190: ,c_action_id number
191: )
192: is
193: select nvl(efc.pgm_uom,efc.nip_pl_uom)
194: from ben_vrbl_rt_prfl_f_efc efc
195: where efc.efc_action_id = c_action_id
196: and efc.vrbl_rt_prfl_id = c_vpf_id
197: and efc.effective_start_date = c_esd;
198: --

Line 287: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_VRBL_RT_PRFL_F';

283: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';
284: l_ele_num := l_ele_num+1;
285: --
286: l_rndgtabnm_set.extend(1);
287: l_rndgtabnm_set(l_ele_num).tab_name := 'BEN_VRBL_RT_PRFL_F';
288: l_rndgtabnm_set(l_ele_num).pkcol_name := 'VRBL_RT_PRFL_ID';
289: l_rndgtabnm_set(l_ele_num).rndgcol_name := 'RNDG_CD';
290: l_rndgtabnm_set(l_ele_num).ent_scode := 'VPF';
291: l_rndgtabnm_set(l_ele_num).datetracked := 'Y';

Line 537: elsif l_rndgtab_name = 'BEN_VRBL_RT_PRFL_F'

533: --
534: end if;
535: close c_get_ppv_currcode;
536: --
537: elsif l_rndgtab_name = 'BEN_VRBL_RT_PRFL_F'
538: then
539: --
540: open c_get_vpf_currcode
541: (c_vpf_id => l_rndgcodedets.id

Line 638: and l_rndgtab_name = 'BEN_VRBL_RT_PRFL_F'

634: where prtl_mo_rt_prtn_val_id = l_rndgcodedets.id
635: and effective_start_date = l_rndgcodedets.effective_start_date;
636: --
637: elsif l_newrndg_code is not null
638: and l_rndgtab_name = 'BEN_VRBL_RT_PRFL_F'
639: then
640: --
641: update ben_vrbl_rt_prfl_f
642: set rndg_cd = l_newrndg_code

Line 641: update ben_vrbl_rt_prfl_f

637: elsif l_newrndg_code is not null
638: and l_rndgtab_name = 'BEN_VRBL_RT_PRFL_F'
639: then
640: --
641: update ben_vrbl_rt_prfl_f
642: set rndg_cd = l_newrndg_code
643: where vrbl_rt_prfl_id = l_rndgcodedets.id
644: and effective_start_date = l_rndgcodedets.effective_start_date;
645: --