APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_PRTT_PREM_F

Line 1812: from ben_prtt_prem_f

1808: l_enrt_ctfn c_enrt_ctfn_for_past_pil%rowtype;
1809: --
1810: cursor c_check_prem_active is
1811: select 1
1812: from ben_prtt_prem_f
1813: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1814: and effective_end_date = hr_api.g_eot;
1815: l_check_prem_active c_check_prem_active%rowtype;
1816: --

Line 1819: from ben_prtt_prem_f ppm

1815: l_check_prem_active c_check_prem_active%rowtype;
1816: --
1817: cursor c_ended_prem_details is
1818: select ppm.prtt_prem_id, ppm.effective_start_date, ppm.object_version_number
1819: from ben_prtt_prem_f ppm
1820: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1821: and ppm.effective_end_date <> hr_api.g_eot
1822: and not exists (select 1
1823: from ben_prtt_prem_f ppm2

Line 1823: from ben_prtt_prem_f ppm2

1819: from ben_prtt_prem_f ppm
1820: where ppm.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1821: and ppm.effective_end_date <> hr_api.g_eot
1822: and not exists (select 1
1823: from ben_prtt_prem_f ppm2
1824: where ppm2.prtt_prem_id = ppm.prtt_prem_id
1825: and ppm2.effective_end_date > ppm.effective_end_date)
1826: order by effective_start_date desc;
1827: l_ended_prem_details c_ended_prem_details%rowtype;