APPS.BEN_PAC_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 303: from ben_rltd_per_chg_cs_ler_f rpc

299: and lpl.ler_id = ler.ler_id)
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

Line 335: ben_rltd_per_chg_cs_ler_f rpc

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
339: and l_session_date between rpc.effective_start_date and rpc.effective_end_date

Line 380: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;

376: l_changed BOOLEAN;
377: l_ler_id NUMBER;
378: l_typ_cd ben_ler_f.typ_cd%type ;
379: l_ocrd_dt_cd VARCHAR2(30);
380: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;
381: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
382: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
383: l_per_info_chg_cs_ler_rl number;
384: l_ovn NUMBER;

Line 381: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;

377: l_ler_id NUMBER;
378: l_typ_cd ben_ler_f.typ_cd%type ;
379: l_ocrd_dt_cd VARCHAR2(30);
380: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;
381: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
382: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
383: l_per_info_chg_cs_ler_rl number;
384: l_ovn NUMBER;
385: l_ptnl_id NUMBER;

Line 382: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;

378: l_typ_cd ben_ler_f.typ_cd%type ;
379: l_ocrd_dt_cd VARCHAR2(30);
380: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;
381: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
382: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
383: l_per_info_chg_cs_ler_rl number;
384: l_ovn NUMBER;
385: l_ptnl_id NUMBER;
386: l_effective_end_date DATE := to_date('31-12-4712','DD-MM-YYYY');