APPS.BEN_ABS_LER dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 293: from ben_rltd_per_chg_cs_ler_f rpc,

289: and lpl.ler_id = ler.ler_id)
290: )
291: or (exists
292: (select 1
293: from ben_rltd_per_chg_cs_ler_f rpc,
294: ben_ler_rltd_per_cs_ler_f lrp
295: where source_table = 'PER_ABSENCE_ATTENDANCES'
296: and lrp.business_group_id = rpc.business_group_id
297: and lrp.business_group_id = ler.business_group_id

Line 335: ben_rltd_per_chg_cs_ler_f rpc

331: rpc.old_val,
332: 'R',
333: rpc.rltd_per_chg_cs_ler_rl per_info_chg_cs_ler, rpc.rule_overrides_flag, nvl(lrp.chg_mandatory_cd,'Y')
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 = nvl(p_new.business_group_id,p_old.business_group_id)
338: and lrp.business_group_id = rpc.business_group_id
339: and l_session_date

Line 374: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);

370: order by person_id;
371: --
372: l_changed BOOLEAN;
373: l_ler_id NUMBER;
374: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
375: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
376: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
377: l_ocrd_dt_cd VARCHAR2(30);
378: l_bool boolean;

Line 375: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);

371: --
372: l_changed BOOLEAN;
373: l_ler_id NUMBER;
374: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
375: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
376: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
377: l_ocrd_dt_cd VARCHAR2(30);
378: l_bool boolean;
379: -- ABSENCES

Line 376: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);

372: l_changed BOOLEAN;
373: l_ler_id NUMBER;
374: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
375: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
376: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
377: l_ocrd_dt_cd VARCHAR2(30);
378: l_bool boolean;
379: -- ABSENCES
380: l_typ_cd VARCHAR2(30);