APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PER_CM_F

Line 131: procedure pop_ben_per_cm_f

127: hr_utility.set_location('Leaving: '||l_proc,10);
128: --
129: end rule_passes;
130: --
131: procedure pop_ben_per_cm_f
132: (p_person_id in number
133: ,p_ler_id in number
134: ,p_per_in_ler_id in number
135: ,p_prtt_enrt_actn_id in number

Line 151: l_proc varchar2(80) := g_package||'pop_ben_per_cm_f';

147: ,p_per_cm_id out nocopy number
148: )
149: is
150: --
151: l_proc varchar2(80) := g_package||'pop_ben_per_cm_f';
152: --
153: -- Output variables
154: --
155: l_object_version_number number;

Line 176: from ben_per_cm_f pcm, ben_per_in_ler pil

172: ,c_comm_sdt date
173: )
174: is
175: select pcm.per_cm_id
176: from ben_per_cm_f pcm, ben_per_in_ler pil
177: -- if commu table has no ler id dont compare , pil_id take care
178: -- of validation # 3296015
179: where (pcm.ler_id is null or pcm.ler_id = c_ler_id)
180: and nvl(pcm.prtt_enrt_actn_id,-1) = nvl(c_pna_id,-1)

Line 213: from ben_per_cm_f pcm,ben_per_cm_prvdd_f pcpf

209: ,c_comm_sdt date
210: )
211: is
212: select pcm.per_cm_id
213: from ben_per_cm_f pcm,ben_per_cm_prvdd_f pcpf
214: where pcm.per_in_ler_id = c_pil_id
215: -- if commu table has no ler id dont compare , pil_id take care
216: -- of validation # 3296015
217: and (pcm.ler_id is null or pcm.ler_id = c_ler_id)

Line 247: from ben_per_cm_f pcm

243: ,c_comm_sdt date
244: )
245: is
246: select pcm.per_cm_id
247: from ben_per_cm_f pcm
248: where pcm.person_id = c_per_id
249: -- if commu table has no ler id dont compare , pil_id take care
250: -- of validation # 3296015
251: and (pcm.ler_id is null or pcm.ler_id = c_ler_id)

Line 628: end pop_ben_per_cm_f;

624: end if;
625: --
626: hr_utility.set_location('Leaving: '||l_proc,10);
627: --
628: end pop_ben_per_cm_f;
629: --
630: procedure pop_ben_per_cm_trgr_f(p_per_cm_id in number,
631: p_cm_trgr_id in number,
632: p_business_group_id in number,

Line 4743: -- 4b. Populate ben_per_cm_f

4739: -- 3. Set Savepoint
4740: -- 4. If rule exists and fails then look at next record
4741: -- 5. If whnvr_trgrd_flag = 'Y' then do for all comp objects
4742: -- 4a. Populate ben_cm_trgr_f
4743: -- 4b. Populate ben_per_cm_f
4744: -- 4b. Populate ben_per_cm_prvdd_f
4745: -- 6. If whnvr_trgrd_flag = 'N' then join to cm_typ_usg_f
4746: -- 7. If rule exists or no rule and a usage exists
4747: -- 6a. Populate ben_per_cm_trgr_f

Line 4749: -- 6c. Populate ben_per_cm_f

4745: -- 6. If whnvr_trgrd_flag = 'N' then join to cm_typ_usg_f
4746: -- 7. If rule exists or no rule and a usage exists
4747: -- 6a. Populate ben_per_cm_trgr_f
4748: -- 6b. Populate ben_per_cm_usg_f
4749: -- 6c. Populate ben_per_cm_f
4750: -- 6d. Populate ben_per_cm_prvdd_f
4751: -- 8. Go to 2.
4752: --
4753: -- Step 1.

Line 4847: pop_ben_per_cm_f

4843: l_triggers.proc_cd = 'HPAPRTTDE' then
4844: --
4845: -- Step 5.
4846: --
4847: pop_ben_per_cm_f
4848: (p_person_id => p_person_id,
4849: p_ler_id => p_ler_id,
4850: p_per_in_ler_id => l_per_in_ler_id,
4851: p_prtt_enrt_actn_id => p_prtt_enrt_actn_id,