APPS.BEN_ELEMENT_ENTRY dependencies on BEN_PRTL_MO_RT_PRTN_VAL_F

Line 1758: from BEN_PRTL_MO_RT_PRTN_VAL_F

1754: ,c_start_or_stop_cd in varchar2
1755: )
1756: is
1757: select *
1758: from BEN_PRTL_MO_RT_PRTN_VAL_F
1759: where (acty_base_rt_id = p_acty_base_rt_id or
1760: actl_prem_id = p_actl_prem_id or
1761: cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id
1762: )

Line 1780: from BEN_PRTL_MO_RT_PRTN_VAL_F

1776: ,c_cvg_amt_calc_mthd_id in number
1777: ,c_effective_date in date)
1778: is
1779: select 'Y'
1780: from BEN_PRTL_MO_RT_PRTN_VAL_F
1781: where (acty_base_rt_id = p_acty_base_rt_id or
1782: actl_prem_id = p_actl_prem_id or
1783: cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id
1784: )

Line 1815: p_rec BEN_PRTL_MO_RT_PRTN_VAL_F%ROWTYPE;

1811: --
1812: l_rounded_value number;
1813: l_prorated_amt number;
1814: l_pct_val number;
1815: p_rec BEN_PRTL_MO_RT_PRTN_VAL_F%ROWTYPE;
1816: l_proc varchar2(75) := ' Prorate_amount';
1817: l_result_amt number;
1818: l_outputs ff_exec.outputs_t;
1819: l_return_amt number;

Line 1940: -- Get the correct ben_prtl_mo_rt_prtn_val_f

1936: p_prorate_flag:='Y';
1937: end if;
1938: --
1939: else -- proration method is N - old setup
1940: -- Get the correct ben_prtl_mo_rt_prtn_val_f
1941: --
1942: open get_prtn_row
1943: (c_acty_base_rt_id => p_acty_base_rt_id
1944: ,c_actl_prem_id => p_actl_prem_id