DBA Data[Home] [Help]

APPS.BEN_PRV_LER dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 58: , ben_ler_rltd_per_cs_ler_f lrp

54: )
55: OR (exists
56: (select 1
57: from ben_rltd_per_chg_cs_ler_f rpc
58: , ben_ler_rltd_per_cs_ler_f lrp
59: where source_table = 'BEN_PRTT_RT_VAL'
60: and lrp.business_group_id = rpc.business_group_id
61: and lrp.business_group_id = ler.business_group_id
62: and l_session_date between rpc.effective_start_date

Line 85: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc

81: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
82: and source_table = 'BEN_PRTT_RT_VAL'
83: UNION
84: select rpc.source_column, rpc.new_val, rpc.old_val, 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, lrp.chg_mandatory_cd
85: from ben_ler_rltd_per_cs_ler_f lrp, ben_rltd_per_chg_cs_ler_f rpc
86: where lrp.ler_id = p_ler_id and
87: lrp.business_group_id = p_new.business_group_id
88: and lrp.business_group_id = rpc.business_group_id
89: and l_session_date between rpc.effective_start_date