APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_PRTT_ENRT_ACTN_F

Line 50: from ben_prtt_enrt_actn_f pea

46: --
47: cursor c_get_actn_items_sus(p_prtt_enrt_rslt_id number,
48: p_eff_dt date) is
49: select pea.*
50: from ben_prtt_enrt_actn_f pea
51: ,ben_per_in_ler pil
52: where pea.business_group_id = p_business_group_id
53: and pea.cmpltd_dt is null
54: and pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 65: from ben_prtt_enrt_actn_f pea

61: --
62: cursor c_get_opt_actn_items_unsus(p_eff_dt date) is
63: select pea.*,
64: pen.object_version_number pen_ovn
65: from ben_prtt_enrt_actn_f pea
66: ,ben_prtt_enrt_rslt_f pen
67: ,ben_per_in_ler pil
68: ,ben_ler_f ler
69: where pea.business_group_id = p_business_group_id

Line 1782: from ben_prtt_enrt_actn_f pea,

1778: p_business_group_id in number) is
1779: --
1780: cursor c_get_past_pil (p_per_in_ler_id number) is
1781: select max(pea.per_in_ler_id)
1782: from ben_prtt_enrt_actn_f pea,
1783: ben_per_in_ler pil
1784: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1785: and pea.per_in_ler_id <> p_per_in_ler_id
1786: and pea.business_group_id = p_business_group_id

Line 1792: from ben_prtt_enrt_actn_f

1788: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD');
1789: --
1790: cursor c_actn_item_for_past_pil (p_per_in_ler_id number) is
1791: select prtt_enrt_actn_id, effective_start_date, object_version_number
1792: from ben_prtt_enrt_actn_f
1793: where per_in_ler_id = p_per_in_ler_id
1794: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1795: and effective_end_date < hr_api.g_eot
1796: and business_group_id = p_business_group_id