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 1728: from ben_prtt_enrt_actn_f pea,

1724: p_business_group_id in number) is
1725: --
1726: cursor c_get_past_pil (p_per_in_ler_id number) is
1727: select max(pea.per_in_ler_id)
1728: from ben_prtt_enrt_actn_f pea,
1729: ben_per_in_ler pil
1730: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1731: and pea.per_in_ler_id <> p_per_in_ler_id
1732: and pea.business_group_id = p_business_group_id

Line 1738: from ben_prtt_enrt_actn_f

1734: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD');
1735: --
1736: cursor c_actn_item_for_past_pil (p_per_in_ler_id number) is
1737: select prtt_enrt_actn_id, effective_start_date, object_version_number
1738: from ben_prtt_enrt_actn_f
1739: where per_in_ler_id = p_per_in_ler_id
1740: and prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1741: and effective_end_date < hr_api.g_eot
1742: and business_group_id = p_business_group_id