DBA Data[Home] [Help]

APPS.BEN_PRTT_ENRT_ACTN_API dependencies on BEN_PER_CM_F

Line 994: from ben_per_cm_f pcm

990: --
991: cursor c_pcm is
992: select pcm.per_cm_id,
993: pcm.object_version_number
994: from ben_per_cm_f pcm
995: where pcm.prtt_enrt_actn_id = p_prtt_enrt_actn_id
996: and pcm.business_group_id = p_business_group_id
997: and p_effective_date between
998: pcm.effective_start_date and pcm.effective_end_date;

Line 1438: from ben_per_cm_f pcm

1434: --
1435: cursor c_pcm is
1436: select pcm.per_cm_id,
1437: pcm.object_version_number
1438: from ben_per_cm_f pcm
1439: where pcm.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1440: and pcm.business_group_id = p_business_group_id
1441: and p_effective_date between
1442: pcm.effective_start_date and pcm.effective_end_date;

Line 1880: from ben_per_cm_f

1876: select per_cm_id,
1877: object_version_number,
1878: effective_start_date,
1879: effective_end_date
1880: from ben_per_cm_f
1881: where prtt_enrt_actn_id = p_prtt_enrt_actn_id
1882: and business_group_id = p_business_group_id
1883: and p_effective_date between effective_start_date
1884: and effective_end_date;