APPS.PQH_GSP_HR_TO_STAGE dependencies on BEN_PRTN_ELIG_PRFL_F

Line 1861: from ben_prtn_elig_prfl_f

1857: function get_ep_id(p_prtn_elig_prfl_id in number,
1858: p_effective_date in date) return number is
1859: cursor csr_elp is
1860: select eligy_prfl_id
1861: from ben_prtn_elig_prfl_f
1862: where p_effective_date between effective_start_date and effective_end_date
1863: and prtn_elig_prfl_id = p_prtn_elig_prfl_id;
1864: l_ep_id number;
1865: begin