APPS.BEN_ABS_LER dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 278: from ben_per_info_chg_cs_ler_f psl,

274: --
275: and (l_status = 'I' or ler.typ_cd in ( 'ABS','CHECKLIST' ))
276: and ((exists
277: (select 1
278: from ben_per_info_chg_cs_ler_f psl,
279: ben_ler_per_info_cs_ler_f lpl
280: where source_table = 'PER_ABSENCE_ATTENDANCES'
281: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
282: and lpl.business_group_id = psl.business_group_id

Line 316: ben_per_info_chg_cs_ler_f psl

312: psl.old_val,
313: 'P',
314: psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag, nvl(lpl.chg_mandatory_cd,'Y')
315: from ben_ler_per_info_cs_ler_f lpl,
316: ben_per_info_chg_cs_ler_f psl
317: where lpl.ler_id = p_ler_id
318: and lpl.business_group_id = nvl(p_new.business_group_id,p_old.business_group_id)
319: and lpl.business_group_id = psl.business_group_id
320: and l_session_date