DBA Data[Home] [Help]

APPS.BEN_PAC_LER dependencies on BEN_LER_PER_INFO_CS_LER_F

Line 292: , ben_ler_per_info_cs_ler_f lpl

288: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
289: and ((exists
290: (select 1
291: from ben_per_info_chg_cs_ler_f psl
292: , ben_ler_per_info_cs_ler_f lpl
293: where source_table like 'PER_PERSON_ANALYSES%'
294: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
295: and lpl.business_group_id = psl.business_group_id
296: and lpl.business_group_id = ler.business_group_id

Line 320: from ben_ler_per_info_cs_ler_f lpl,

316: select psl.source_column, psl.new_val, psl.old_val,
317: 'P', psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag,
318: lpl.chg_mandatory_cd, psl.source_table ,
319: substr(psl.source_table, instr(psl.source_table, '-')+2 ,length(psl.source_table)) l_context
320: from ben_ler_per_info_cs_ler_f lpl,
321: ben_per_info_chg_cs_ler_f psl
322: where lpl.ler_id = p_ler_id
323: and lpl.business_group_id = p_new.business_group_id
324: and lpl.business_group_id = psl.business_group_id