DBA Data[Home] [Help]

APPS.BEN_EEV_LER dependencies on BEN_LER_RLTD_PER_CS_LER

Line 53: ben_ler_rltd_per_cs_ler lrp

49: and lpl.ler_id = ler.ler_id)
50: OR
51: exists (select 1 from
52: ben_rltd_per_chg_cs_ler_f rpc,
53: ben_ler_rltd_per_cs_ler lrp
54: where source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
55: and lrp.business_group_id = rpc.business_group_id
56: and lrp.business_group_id = ler.business_group_id
57: and l_session_date between rpc.effective_start_date

Line 77: from ben_ler_rltd_per_cs_ler lrp, ben_rltd_per_chg_cs_ler_f rpc

73: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
74: and source_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
75: UNION
76: 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
77: from ben_ler_rltd_per_cs_ler lrp, ben_rltd_per_chg_cs_ler_f rpc
78: where lrp.ler_id = p_ler_id and
79: lrp.business_group_id = l_business_group_id
80: and lrp.business_group_id = rpc.business_group_id
81: and l_session_date between rpc.effective_start_date