APPS.PQH_PA_WHATIF_PROCESS dependencies on BEN_PTNL_LER_FOR_PER

Line 76: FROM ben_ptnl_ler_for_per ptn

72: RETURN VARCHAR2 IS
73: --
74: CURSOR csr_chk_ptnl_ler(p_person_id NUMBER, p_business_group_id NUMBER) IS
75: SELECT lf_evt_ocrd_dt
76: FROM ben_ptnl_ler_for_per ptn
77: WHERE ptn.person_id = p_person_id
78: AND ptn.business_group_id = p_business_group_id
79: AND ptn.ler_id IN ( SELECT ler_id FROM ben_ler_f ler WHERE ler.typ_cd NOT IN ('COMP','SCHEDDU','SCHEDDO'))
80: AND ptn.ptnl_ler_for_per_stat_cd NOT IN('VOIDD','PROCD');

Line 120: FROM ben_ptnl_ler_for_per ptn,

116: RETURN BOOLEAN IS
117: --
118: CURSOR csr_chk_cnflt_ler IS
119: SELECT ptn.ler_id,ler.name,ler.ovridg_le_flag
120: FROM ben_ptnl_ler_for_per ptn,
121: ben_ler_f ler
122: WHERE ptn.person_id = p_person_id
123: AND ptn.business_group_id = p_business_group_id
124: AND ptn.ler_id =ler.ler_id

Line 189: UPDATE ben_ptnl_ler_for_per

185: l_proc := g_package || 'void_potential_life_events';
186: hr_utility.set_location('Entering: ' || l_proc,10);
187: end if;
188:
189: UPDATE ben_ptnl_ler_for_per
190: SET ptnl_ler_for_per_stat_cd = 'VOIDD'
191: WHERE person_id = p_person_id
192: AND business_group_id = p_business_group_id
193: AND ler_id in ( select ler_id from ben_ler_f ler where ler.typ_cd NOT IN ('COMP','SCHEDDU','SCHEDDO'))

Line 249: UPDATE ben_ptnl_ler_for_per

245: l_proc := g_package || '.void_conflict_life_events';
246: hr_utility.set_location('Entering: ' || l_proc,10);
247: end if;
248:
249: UPDATE ben_ptnl_ler_for_per
250: SET ptnl_ler_for_per_stat_cd = 'VOIDD'
251: WHERE person_id = p_person_id
252: AND business_group_id = p_business_group_id
253: AND ler_id in ( select ler_id from ben_ler_f ler where ler.typ_cd NOT IN ('COMP','SCHEDDU','SCHEDDO')

Line 3929: from ben_ptnl_ler_for_per ptn,

3925: cursor c_ptnl_le(l_lf_evt_ocrd_dt date) is
3926: select ptn.ptnl_ler_for_per_id,
3927: ptn.ptnl_ler_for_per_stat_cd,
3928: ptn.lf_evt_ocrd_dt lf_evt_ocrd_dt
3929: from ben_ptnl_ler_for_per ptn,
3930: ben_ler_f ler
3931: where ptn.person_id = p_person_id
3932: and ptn.business_group_id = p_business_group_id
3933: and ptn.lf_evt_ocrd_dt > l_lf_evt_ocrd_dt