DBA Data[Home] [Help]

APPS.BEN_ABS_LER dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 294: ben_ler_rltd_per_cs_ler_f lrp

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
298: and l_session_date

Line 334: from ben_ler_rltd_per_cs_ler_f lrp,

330: rpc.new_val,
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