DBA Data[Home] [Help]

APPS.BEN_PPF_LER dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 32: from ben_per_info_chg_cs_ler_f psl

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

Line 68: , ben_per_info_chg_cs_ler_f psl

64: , psl.new_val
65: , psl.old_val
66: , 'P', psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag, lpl.chg_mandatory_cd
67: from ben_ler_per_info_cs_ler_f lpl
68: , ben_per_info_chg_cs_ler_f psl
69: where lpl.ler_id = p_ler_id
70: and lpl.business_group_id = p_new.business_group_id
71: and lpl.business_group_id = psl.business_group_id
72: and l_session_date between