APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_VRBL_RT_PRFL_F_EFC

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: --