APPS.BEN_PPR_BUS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 383: FROM ben_elig_cvrd_dpnt_f becd,

379:
380:
381: CURSOR c2 IS
382: SELECT bper.prtt_enrt_rslt_id
383: FROM ben_elig_cvrd_dpnt_f becd,
384: ben_prtt_enrt_rslt_f bper,
385: ben_pl_pcp bpp
386: WHERE becd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
387: AND becd.prtt_enrt_rslt_id = bper.prtt_enrt_rslt_id

Line 405: FROM ben_elig_cvrd_dpnt_f becd,

401: AND p_effective_date BETWEEN bper.effective_start_date and bper.effective_end_date;
402:
403: CURSOR c4 IS
404: SELECT bper.prtt_enrt_rslt_id
405: FROM ben_elig_cvrd_dpnt_f becd,
406: ben_prtt_enrt_rslt_f bper,
407: ben_oipl_f oipl
408: WHERE becd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
409: AND becd.prtt_enrt_rslt_id = bper.prtt_enrt_rslt_id

Line 578: from ben_elig_cvrd_dpnt_f

574: and effective_end_date;
575:
576: cursor c_rslt_id is
577: select distinct prtt_enrt_rslt_id, dpnt_person_id
578: from ben_elig_cvrd_dpnt_f
579: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
580: and p_effective_date between effective_start_date
581: and effective_end_date;
582:

Line 681: from ben_elig_cvrd_dpnt_f

677: l_num_of_chgs number := 0;
678:
679: cursor c_prtt_enrt_rslt_id is
680: select distinct prtt_enrt_rslt_id
681: from ben_elig_cvrd_dpnt_f
682: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id;
683:
684: cursor c_pcp (p_prtt_enrt_rslt_id number) is
685: select pcp.pcp_num_chgs

Line 808: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',

804: p_argument_value => p_validation_end_date);
805: --
806: If ((nvl(p_elig_cvrd_dpnt_id, hr_api.g_number) <> hr_api.g_number) and
807: NOT (dt_api.check_min_max_dates
808: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',
809: p_base_key_column => 'elig_cvrd_dpnt_id',
810: p_base_key_value => p_elig_cvrd_dpnt_id,
811: p_from_date => p_validation_start_date,
812: p_to_date => p_validation_end_date))) Then

Line 813: l_table_name := 'ben_elig_cvrd_dpnt_f';

809: p_base_key_column => 'elig_cvrd_dpnt_id',
810: p_base_key_value => p_elig_cvrd_dpnt_id,
811: p_from_date => p_validation_start_date,
812: p_to_date => p_validation_end_date))) Then
813: l_table_name := 'ben_elig_cvrd_dpnt_f';
814: Raise l_integrity_error;
815: End If;
816: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
817: NOT (dt_api.check_min_max_dates