DBA Data[Home] [Help]

APPS.BEN_EFC_RNDG_CD_UPGRADE dependencies on BEN_ACTY_BASE_RT_F_EFC

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