APPS.BEN_PCS_BUS dependencies on BEN_PRTT_ENRT_ACTN_F

Line 309: from ben_prtt_enrt_actn_f actn,

305: l_due_dt date;
306: --
307: CURSOR c1 IS
308: select actn.due_dt
309: from ben_prtt_enrt_actn_f actn,
310: ben_prtt_enrt_ctfn_prvdd_f ctfn
311: where ctfn.prtt_enrt_actn_id = actn.prtt_enrt_actn_id
312: and ctfn.prtt_enrt_rslt_id = actn.prtt_enrt_rslt_id
313: and ctfn.prtt_enrt_actn_id = p_prtt_enrt_actn_id

Line 496: (p_base_table_name => 'ben_prtt_enrt_actn_f',

492: p_argument_value => p_validation_end_date);
493: --
494: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and
495: NOT (dt_api.check_min_max_dates
496: (p_base_table_name => 'ben_prtt_enrt_actn_f',
497: p_base_key_column => 'prtt_enrt_actn_id',
498: p_base_key_value => p_prtt_enrt_actn_id,
499: p_from_date => p_validation_start_date,
500: p_to_date => p_validation_end_date))) Then

Line 501: l_table_name := 'ben_prtt_enrt_actn_f';

497: p_base_key_column => 'prtt_enrt_actn_id',
498: p_base_key_value => p_prtt_enrt_actn_id,
499: p_from_date => p_validation_start_date,
500: p_to_date => p_validation_end_date))) Then
501: l_table_name := 'ben_prtt_enrt_actn_f';
502: Raise l_integrity_error;
503: End If;
504: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
505: NOT (dt_api.check_min_max_dates