APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PER_CM_PRVDD_F

Line 578: procedure pop_ben_per_cm_prvdd_f(p_per_cm_id in number,

574: hr_utility.set_location('Leaving: '||l_proc,10);
575: --
576: end pop_ben_per_cm_trgr_f;
577: --
578: procedure pop_ben_per_cm_prvdd_f(p_per_cm_id in number,
579: p_effective_date in date,
580: p_rqstd_flag in varchar2,
581: p_inspn_rqd_flag in varchar2,
582: p_per_cm_prvdd_stat_cd in varchar2,

Line 592: l_proc varchar2(80) := g_package||'pop_ben_per_cm_prvdd_f';

588: p_address_id in number,
589: p_business_group_id in number,
590: p_per_cm_prvdd_id out nocopy number) is
591: --
592: l_proc varchar2(80) := g_package||'pop_ben_per_cm_prvdd_f';
593: --
594: -- Output variables
595: --
596: l_object_version_number number;

Line 602: from ben_per_cm_prvdd_f pcd

598: l_effective_end_date date;
599: --
600: cursor c_per_cm_prvdd is
601: select pcd.*
602: from ben_per_cm_prvdd_f pcd
603: where pcd.per_cm_id = p_per_cm_id
604: and pcd.sent_dt is null
605: and pcd.business_group_id = p_business_group_id
606: and ben_generate_communications.g_comm_start_date

Line 612: from ben_per_cm_prvdd_f pcd

608: and pcd.effective_end_date;
609: --
610: cursor c_get_instnc_num is
611: select max(pcd.instnc_num)
612: from ben_per_cm_prvdd_f pcd
613: where pcd.per_cm_id = p_per_cm_id
614: and pcd.business_group_id = p_business_group_id
615: and ben_generate_communications.g_comm_start_date
616: between pcd.effective_start_date

Line 705: end pop_ben_per_cm_prvdd_f;

701: end if;
702: --
703: hr_utility.set_location('Leaving: '||l_proc,10);
704: --
705: end pop_ben_per_cm_prvdd_f;
706: --
707: procedure pop_ben_per_cm_usg_f
708: (p_per_cm_id in number,
709: p_cm_typ_usg_id in number,

Line 823: pop_ben_per_cm_prvdd_f

819: p_business_group_id => p_business_group_id,
820: p_effective_date => p_effective_date,
821: p_per_cm_trgr_id => l_per_cm_trgr_id);
822: --
823: pop_ben_per_cm_prvdd_f
824: (p_per_cm_id => p_per_cm_id,
825: p_rqstd_flag => 'N',
826: p_inspn_rqd_flag => p_inspn_rqd_flag,
827: p_per_cm_prvdd_stat_cd => 'ACTIVE',

Line 3611: from ben_per_cm_prvdd_f

3607: -- 3717297 the hipaa communication called from benmngle and close enrollment
3608: -- to avoid the dups
3609: cursor c_pcd is
3610: select 'x'
3611: from ben_per_cm_prvdd_f
3612: where per_cm_id = p_per_cm_id
3613: --
3614: -- Bug No: 3752029
3615: -- Commented out this condition since it was only allowing selecting records for which we

Line 4410: -- 4b. Populate ben_per_cm_prvdd_f

4406: -- 4. If rule exists and fails then look at next record
4407: -- 5. If whnvr_trgrd_flag = 'Y' then do for all comp objects
4408: -- 4a. Populate ben_cm_trgr_f
4409: -- 4b. Populate ben_per_cm_f
4410: -- 4b. Populate ben_per_cm_prvdd_f
4411: -- 6. If whnvr_trgrd_flag = 'N' then join to cm_typ_usg_f
4412: -- 7. If rule exists or no rule and a usage exists
4413: -- 6a. Populate ben_per_cm_trgr_f
4414: -- 6b. Populate ben_per_cm_usg_f

Line 4416: -- 6d. Populate ben_per_cm_prvdd_f

4412: -- 7. If rule exists or no rule and a usage exists
4413: -- 6a. Populate ben_per_cm_trgr_f
4414: -- 6b. Populate ben_per_cm_usg_f
4415: -- 6c. Populate ben_per_cm_f
4416: -- 6d. Populate ben_per_cm_prvdd_f
4417: -- 8. Go to 2.
4418: --
4419: -- Step 1.
4420: --