APPS.BEN_CER_BUS dependencies on BEN_PRTN_ELIG_F

Line 412: from ben_prtn_elig_f prtn, ben_pl_f p

408: l_exists varchar2(1);
409: --
410: cursor c1 is
411: select null
412: from ben_prtn_elig_f prtn, ben_pl_f p
413: where prtn.prtn_elig_id = p_prtn_elig_id
414: and prtn.pl_id = p.pl_id
415: and (p.invk_flx_cr_pl_flag = 'Y'
416: or

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

421: and p.effective_end_date;
422: --
423: cursor c2 is
424: select null
425: from ben_prtn_elig_f epa, ben_pl_f pln, ben_plip_f plip
426: where epa.prtn_elig_id = p_prtn_elig_id
427: and epa.plip_id = plip.plip_id
428: and plip.pl_id = pln.pl_id
429: and (pln.invk_flx_cr_pl_flag = 'Y'

Line 546: (p_base_table_name => 'ben_prtn_elig_f',

542: p_argument_value => p_validation_end_date);
543: --
544: If ((nvl(p_prtn_elig_id, hr_api.g_number) <> hr_api.g_number) and
545: NOT (dt_api.check_min_max_dates
546: (p_base_table_name => 'ben_prtn_elig_f',
547: p_base_key_column => 'prtn_elig_id',
548: p_base_key_value => p_prtn_elig_id,
549: p_from_date => p_validation_start_date,
550: p_to_date => p_validation_end_date))) Then

Line 551: l_table_name := 'ben_prtn_elig_f';

547: p_base_key_column => 'prtn_elig_id',
548: p_base_key_value => p_prtn_elig_id,
549: p_from_date => p_validation_start_date,
550: p_to_date => p_validation_end_date))) Then
551: l_table_name := 'ben_prtn_elig_f';
552: Raise l_integrity_error;
553: End If;
554: --
555: End If;