DBA Data[Home] [Help]

APPS.BEN_QUA_LER dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 43: , ben_ler_rltd_per_cs_ler_f lrp

39: )
40: OR (exists
41: (select 1
42: from ben_rltd_per_chg_cs_ler_f rpc
43: , ben_ler_rltd_per_cs_ler_f lrp
44: where source_table = 'PER_QUALIFICATIONS'
45: and lrp.business_group_id = rpc.business_group_id
46: and lrp.business_group_id = ler.business_group_id
47: and l_session_date between rpc.effective_start_date

Line 79: from ben_ler_rltd_per_cs_ler_f lrp

75: select rpc.source_column
76: , rpc.new_val
77: , rpc.old_val
78: , 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
79: from ben_ler_rltd_per_cs_ler_f lrp
80: , ben_rltd_per_chg_cs_ler_f rpc
81: where lrp.ler_id = p_ler_id
82: and lrp.business_group_id = p_new.business_group_id
83: and lrp.business_group_id = rpc.business_group_id