APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_PRTT_PREM_F

Line 1758: from ben_prtt_prem_f

1754: l_enrt_ctfn c_enrt_ctfn_for_past_pil%rowtype;
1755: --
1756: cursor c_check_prem_active is
1757: select 1
1758: from ben_prtt_prem_f
1759: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1760: and effective_end_date = hr_api.g_eot;
1761: l_check_prem_active c_check_prem_active%rowtype;
1762: --

Line 1765: from ben_prtt_prem_f ppm

1761: l_check_prem_active c_check_prem_active%rowtype;
1762: --
1763: cursor c_ended_prem_details is
1764: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number
1765: from ben_prtt_prem_f ppm
1766: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1767: and ppm.effective_end_date <> hr_api.g_eot
1768: and not exists (select 1
1769: from ben_prtt_prem_f ppm2

Line 1769: from ben_prtt_prem_f ppm2

1765: from ben_prtt_prem_f ppm
1766: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1767: and ppm.effective_end_date <> hr_api.g_eot
1768: and not exists (select 1
1769: from ben_prtt_prem_f ppm2
1770: where ppm2.prtt_prem_id = ppm.prtt_prem_id
1771: and ppm2.effective_end_date > ppm.effective_end_date)
1772: order by effective_start_date desc;
1773: l_ended_prem_details c_ended_prem_details%rowtype;