APPS.BEN_ELEMENT_ENTRY dependencies on BEN_PRTL_MO_RT_PRTN_VAL_F

Line 1757: from BEN_PRTL_MO_RT_PRTN_VAL_F

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

Line 1779: from BEN_PRTL_MO_RT_PRTN_VAL_F

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

Line 1791: p_rec BEN_PRTL_MO_RT_PRTN_VAL_F%ROWTYPE;

1787: --
1788: l_rounded_value number;
1789: l_prorated_amt number;
1790: l_pct_val number;
1791: p_rec BEN_PRTL_MO_RT_PRTN_VAL_F%ROWTYPE;
1792: l_proc varchar2(75) := ' Prorate_amount';
1793: l_result_amt number;
1794: l_outputs ff_exec.outputs_t;
1795: l_return_amt number;

Line 1915: -- Get the correct ben_prtl_mo_rt_prtn_val_f

1911: p_prorate_flag:='Y';
1912: end if;
1913: --
1914: else -- proration method is N - old setup
1915: -- Get the correct ben_prtl_mo_rt_prtn_val_f
1916: --
1917: open get_prtn_row
1918: (c_acty_base_rt_id => p_acty_base_rt_id
1919: ,c_actl_prem_id => p_actl_prem_id