APPS.BEN_CEP_BUS dependencies on BEN_PRTN_ELIG_F

Line 348: from ben_prtn_elig_f prtn, ben_pl_f p

344: l_exists varchar2(1);
345: --
346: cursor c1 is
347: select null
348: from ben_prtn_elig_f prtn, ben_pl_f p
349: where prtn.prtn_elig_id = p_prtn_elig_id
350: and prtn.pl_id = p.pl_id
351: and (p.invk_flx_cr_pl_flag = 'Y'
352: or

Line 361: from ben_prtn_elig_f epa, ben_pl_f pln, ben_plip_f plip

357: and p.effective_end_date;
358: --
359: cursor c2 is
360: select null
361: from ben_prtn_elig_f epa, ben_pl_f pln, ben_plip_f plip
362: where epa.prtn_elig_id = p_prtn_elig_id
363: and epa.plip_id = plip.plip_id
364: and plip.pl_id = pln.pl_id
365: and (pln.invk_flx_cr_pl_flag = 'Y'

Line 493: (p_base_table_name => 'ben_prtn_elig_f',

489: Raise l_integrity_error;
490: End If;
491: If ((nvl(p_prtn_elig_id, hr_api.g_number) <> hr_api.g_number) and
492: NOT (dt_api.check_min_max_dates
493: (p_base_table_name => 'ben_prtn_elig_f',
494: p_base_key_column => 'prtn_elig_id',
495: p_base_key_value => p_prtn_elig_id,
496: p_from_date => p_validation_start_date,
497: p_to_date => p_validation_end_date))) Then

Line 498: l_table_name := 'ben_prtn_elig_f';

494: p_base_key_column => 'prtn_elig_id',
495: p_base_key_value => p_prtn_elig_id,
496: p_from_date => p_validation_start_date,
497: p_to_date => p_validation_end_date))) Then
498: l_table_name := 'ben_prtn_elig_f';
499: Raise l_integrity_error;
500: End If;
501: --
502: End If;