DBA Data[Home] [Help]

APPS.BEN_CCP_BUS dependencies on BEN_PRTT_ENRT_ACTN_F

Line 193: ben_prtt_enrt_actn_f pea,

189: --
190: cursor c3 is
191: select null
192: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
193: ben_prtt_enrt_actn_f pea,
194: ben_per_in_ler pil
195: where ccp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
196: and ccp.dpnt_dsgn_ctfn_typ_cd = p_dpnt_dsgn_ctfn_typ_cd
197: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id

Line 412: (p_base_table_name => 'ben_prtt_enrt_actn_f',

408: Raise l_integrity_error;
409: End If;
410: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and
411: NOT (dt_api.check_min_max_dates
412: (p_base_table_name => 'ben_prtt_enrt_actn_f',
413: p_base_key_column => 'prtt_enrt_actn_id',
414: p_base_key_value => p_prtt_enrt_actn_id,
415: p_from_date => p_validation_start_date,
416: p_to_date => p_validation_end_date))) Then

Line 417: l_table_name := 'ben_prtt_enrt_actn_f';

413: p_base_key_column => 'prtt_enrt_actn_id',
414: p_base_key_value => p_prtt_enrt_actn_id,
415: p_from_date => p_validation_start_date,
416: p_to_date => p_validation_end_date))) Then
417: l_table_name := 'ben_prtt_enrt_actn_f';
418: Raise l_integrity_error;
419: End If;
420: --
421: End If;