DBA Data[Home] [Help]

APPS.BEN_PAC_LER dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 304: , ben_ler_rltd_per_cs_ler_f lrp

300: )
301: OR (exists
302: (select 1
303: from ben_rltd_per_chg_cs_ler_f rpc
304: , ben_ler_rltd_per_cs_ler_f lrp
305: where source_table like 'PER_PERSON_ANALYSES%'
306: and lrp.business_group_id = rpc.business_group_id
307: and lrp.business_group_id = ler.business_group_id
308: and l_session_date between rpc.effective_start_date and rpc.effective_end_date

Line 334: from ben_ler_rltd_per_cs_ler_f lrp,

330: select rpc.source_column, rpc.new_val, rpc.old_val,
331: 'R', rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag,
332: lrp.chg_mandatory_cd, rpc.source_table,
333: substr(rpc.source_table, instr(rpc.source_table, '-')+2 ,length(rpc.source_table)) l_context
334: from ben_ler_rltd_per_cs_ler_f lrp,
335: ben_rltd_per_chg_cs_ler_f rpc
336: where lrp.ler_id = p_ler_id
337: and lrp.business_group_id = p_new.business_group_id
338: and lrp.business_group_id = rpc.business_group_id