DBA Data[Home] [Help]

APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PER_CM_TRGR_F

Line 494: procedure pop_ben_per_cm_trgr_f(p_per_cm_id in number,

490: hr_utility.set_location('Leaving: '||l_proc,10);
491: --
492: end pop_ben_per_cm_f;
493: --
494: procedure pop_ben_per_cm_trgr_f(p_per_cm_id in number,
495: p_cm_trgr_id in number,
496: p_business_group_id in number,
497: p_effective_date in date,
498: p_per_cm_trgr_id out nocopy number) is

Line 500: l_proc varchar2(80) := g_package||'pop_ben_per_cm_trgr_f';

496: p_business_group_id in number,
497: p_effective_date in date,
498: p_per_cm_trgr_id out nocopy number) is
499: --
500: l_proc varchar2(80) := g_package||'pop_ben_per_cm_trgr_f';
501: --
502: -- Output variables
503: --
504: l_object_version_number number;

Line 510: from ben_per_cm_trgr_f pcr

506: l_effective_end_date date;
507: --
508: cursor c_per_cm_trgr is
509: select null
510: from ben_per_cm_trgr_f pcr
511: where pcr.cm_trgr_id = p_cm_trgr_id
512: and pcr.per_cm_id = p_per_cm_id
513: and pcr.business_group_id = p_business_group_id
514: and ben_generate_communications.g_comm_start_date

Line 576: end pop_ben_per_cm_trgr_f;

572: close c_per_cm_trgr;
573: --
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,

Line 816: pop_ben_per_cm_trgr_f

812: begin
813: --
814: hr_utility.set_location('Entering: '||l_proc,10);
815: --
816: pop_ben_per_cm_trgr_f
817: (p_per_cm_id => p_per_cm_id,
818: p_cm_trgr_id => p_cm_trgr_id,
819: p_business_group_id => p_business_group_id,
820: p_effective_date => p_effective_date,

Line 4413: -- 6a. Populate ben_per_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
4415: -- 6c. Populate ben_per_cm_f
4416: -- 6d. Populate ben_per_cm_prvdd_f
4417: -- 8. Go to 2.