DBA Data[Home] [Help]

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_PER_CM_F

Line 2811: from ben_per_cm_f pcm,

2807: l_effective_end_date date;
2808: --
2809: cursor c_per_cm is
2810: select pcd.*
2811: from ben_per_cm_f pcm,
2812: ben_per_cm_prvdd_f pcd
2813: where pcm.person_id = p_person_id
2814: and pcm.ler_id = p_ler_id
2815: and pcm.business_group_id = p_business_group_id

Line 2868: from ben_per_cm_f pcm,

2864: l_resnd_cmnt_txt fnd_new_messages.message_text%type;
2865: --
2866: cursor c_per_cm is
2867: select pcd.*
2868: from ben_per_cm_f pcm,
2869: ben_per_cm_prvdd_f pcd
2870: where pcm.person_id = p_person_id
2871: and pcm.ler_id = p_ler_id
2872: and pcm.business_group_id = p_business_group_id

Line 9078: from ben_per_cm_f pcf,

9074: Self Service, on reprocessing the backed out life event, communications of
9075: triggers configured for Web Enrollments should be reinstated.*/
9076: cursor c_chk_web_enrt_exists is
9077: select 'Y'
9078: from ben_per_cm_f pcf,
9079: ben_per_cm_trgr_f pctf,
9080: ben_cm_trgr bct
9081: where pcf.per_in_ler_id = p_bckdt_per_in_ler_id
9082: and pcf.person_id = p_person_id