DBA Data[Home] [Help]

APPS.BEN_QUA_LER dependencies on BEN_LER_PER_INFO_CS_LER_F

Line 29: , ben_ler_per_info_cs_ler_f lpl

25: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
26: and ((exists
27: (select 1
28: from ben_per_info_chg_cs_ler_f psl
29: , ben_ler_per_info_cs_ler_f lpl
30: where source_table = 'PER_QUALIFICATIONS'
31: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
32: and lpl.business_group_id = psl.business_group_id
33: and lpl.business_group_id = ler.business_group_id

Line 62: from ben_ler_per_info_cs_ler_f lpl

58: select psl.source_column
59: , psl.new_val
60: , psl.old_val
61: , 'P', psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag, lpl.chg_mandatory_cd
62: from ben_ler_per_info_cs_ler_f lpl
63: , ben_per_info_chg_cs_ler_f psl
64: where lpl.ler_id = p_ler_id
65: and lpl.business_group_id = p_new.business_group_id
66: and lpl.business_group_id = psl.business_group_id