APPS.BEN_PEN_BUS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 1005: FROM ben_elig_cvrd_dpnt_f pdp, ben_per_in_ler pil

1001: --
1002: CURSOR c_elig_dpnt
1003: IS
1004: SELECT NULL
1005: FROM ben_elig_cvrd_dpnt_f pdp, ben_per_in_ler pil
1006: WHERE pdp.dpnt_person_id = l_dpnt_id
1007: AND pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1008: AND p_effective_date BETWEEN pdp.effective_start_date
1009: AND pdp.effective_end_date

Line 3895: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',

3891:
3892: If p_effective_date < p_validation_start_date then
3893: -- Added the above condition for bug 3646239
3894: If (dt_api.rows_exist
3895: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',
3896: p_base_key_column => 'prtt_enrt_rslt_id',
3897: p_base_key_value => p_prtt_enrt_rslt_id,
3898: p_from_date => p_validation_start_date,
3899: p_to_date => p_validation_end_date)) Then

Line 3900: l_table_name := 'ben_elig_cvrd_dpnt_f';

3896: p_base_key_column => 'prtt_enrt_rslt_id',
3897: p_base_key_value => p_prtt_enrt_rslt_id,
3898: p_from_date => p_validation_start_date,
3899: p_to_date => p_validation_end_date)) Then
3900: l_table_name := 'ben_elig_cvrd_dpnt_f';
3901: Raise l_rows_exist;
3902: End If;
3903: End If;
3904: