APPS.GHR_BENEFITS_EIT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 25: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type, c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,

21: WHERE pgm.name = c_prog_name
22: AND pgm.business_group_id = c_business_group_id
23: AND c_effective_date between effective_start_date and effective_end_date;
24:
25: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type, c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
26: c_effective_date ben_pgm_f.effective_start_date%type) is
27: SELECT 1
28: FROM ben_prtt_enrt_rslt_f
29: WHERE person_id = c_person_id

Line 28: FROM ben_prtt_enrt_rslt_f

24:
25: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type, c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
26: c_effective_date ben_pgm_f.effective_start_date%type) is
27: SELECT 1
28: FROM ben_prtt_enrt_rslt_f
29: WHERE person_id = c_person_id
30: AND pgm_id = c_pgm_id
31: AND prtt_enrt_rslt_stat_cd IS NULL
32: AND c_effective_date between effective_start_date and effective_end_date;

Line 207: from ben_prtt_enrt_rslt_f

203:
204: cursor c_get_cvg_st_dt
205: is
206: select enrt_cvg_strt_dt
207: from ben_prtt_enrt_rslt_f
208: where prtt_enrt_rslt_id = l_prtt_enrt_rslt_id;
209:
210:
211:

Line 624: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type, c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,

620: WHERE pgm.name = c_prog_name
621: AND pgm.business_group_id = c_business_group_id
622: AND c_effective_date between effective_start_date and effective_end_date;
623:
624: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type, c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
625: c_effective_date ben_pgm_f.effective_start_date%type) is
626: SELECT 1
627: FROM ben_prtt_enrt_rslt_f
628: WHERE person_id = c_person_id

Line 627: FROM ben_prtt_enrt_rslt_f

623:
624: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type, c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
625: c_effective_date ben_pgm_f.effective_start_date%type) is
626: SELECT 1
627: FROM ben_prtt_enrt_rslt_f
628: WHERE person_id = c_person_id
629: AND pgm_id = c_pgm_id
630: AND c_effective_date between effective_start_date and effective_end_date;
631: