APPS.BEN_PAC_LER dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 291: from ben_per_info_chg_cs_ler_f psl

287: and l_session_date between ler.effective_start_date and ler.effective_end_date
288: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
289: and ((exists
290: (select 1
291: from ben_per_info_chg_cs_ler_f psl
292: , ben_ler_per_info_cs_ler_f lpl
293: where source_table like 'PER_PERSON_ANALYSES%'
294: and psl.per_info_chg_cs_ler_id = lpl.per_info_chg_cs_ler_id
295: and lpl.business_group_id = psl.business_group_id

Line 321: ben_per_info_chg_cs_ler_f psl

317: 'P', psl.per_info_chg_cs_ler_rl, psl.rule_overrides_flag,
318: lpl.chg_mandatory_cd, psl.source_table ,
319: substr(psl.source_table, instr(psl.source_table, '-')+2 ,length(psl.source_table)) l_context
320: from ben_ler_per_info_cs_ler_f lpl,
321: ben_per_info_chg_cs_ler_f psl
322: where lpl.ler_id = p_ler_id
323: and lpl.business_group_id = p_new.business_group_id
324: and lpl.business_group_id = psl.business_group_id
325: and l_session_date between psl.effective_start_date and psl.effective_end_date

Line 373: l_source_table ben_per_info_chg_cs_ler_f.source_table%TYPE ;

369: --
370: l_param_tab ff_exec.outputs_t ;
371: l_old_pac c_get_pac%rowtype ;
372: l_new_pac c_get_pac%rowtype ;
373: l_source_table ben_per_info_chg_cs_ler_f.source_table%TYPE ;
374: l_context varchar2(30);
375: --
376: l_changed BOOLEAN;
377: l_ler_id NUMBER;