APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_PER_CM_F

Line 124: procedure pop_ben_per_cm_f

120: hr_utility.set_location('Leaving: '||l_proc,10);
121: --
122: end rule_passes;
123: --
124: procedure pop_ben_per_cm_f
125: (p_person_id in number
126: ,p_ler_id in number
127: ,p_per_in_ler_id in number
128: ,p_prtt_enrt_actn_id in number

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

140: ,p_per_cm_id out nocopy number
141: )
142: is
143: --
144: l_proc varchar2(80) := g_package||'pop_ben_per_cm_f';
145: --
146: -- Output variables
147: --
148: l_object_version_number number;

Line 169: from ben_per_cm_f pcm, ben_per_in_ler pil

165: ,c_comm_sdt date
166: )
167: is
168: select pcm.per_cm_id
169: from ben_per_cm_f pcm, ben_per_in_ler pil
170: -- if commu table has no ler id dont compare , pil_id take care
171: -- of validation # 3296015
172: where (pcm.ler_id is null or pcm.ler_id = c_ler_id)
173: and nvl(pcm.prtt_enrt_actn_id,-1) = nvl(c_pna_id,-1)

Line 206: from ben_per_cm_f pcm

202: ,c_comm_sdt date
203: )
204: is
205: select pcm.per_cm_id
206: from ben_per_cm_f pcm
207: where pcm.per_in_ler_id = c_pil_id
208: -- if commu table has no ler id dont compare , pil_id take care
209: -- of validation # 3296015
210: and (pcm.ler_id is null or pcm.ler_id = c_ler_id)

Line 236: from ben_per_cm_f pcm

232: ,c_comm_sdt date
233: )
234: is
235: select pcm.per_cm_id
236: from ben_per_cm_f pcm
237: where pcm.person_id = c_per_id
238: -- if commu table has no ler id dont compare , pil_id take care
239: -- of validation # 3296015
240: and (pcm.ler_id is null or pcm.ler_id = c_ler_id)

Line 492: end pop_ben_per_cm_f;

488: end if;
489: --
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,

Line 4409: -- 4b. Populate ben_per_cm_f

4405: -- 3. Set Savepoint
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

Line 4415: -- 6c. Populate ben_per_cm_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.
4418: --
4419: -- Step 1.

Line 4510: pop_ben_per_cm_f

4506: l_triggers.proc_cd = 'HPAPRTTDE' then
4507: --
4508: -- Step 5.
4509: --
4510: pop_ben_per_cm_f
4511: (p_person_id => p_person_id,
4512: p_ler_id => p_ler_id,
4513: p_per_in_ler_id => l_per_in_ler_id,
4514: p_prtt_enrt_actn_id => p_prtt_enrt_actn_id,