APPS.GHR_SF52_UPDATE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 507: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type,

503: WHERE pgm.name = c_prog_name
504: AND pgm.business_group_id = c_business_group_id
505: AND c_effective_date between effective_start_date and effective_end_date;
506:
507: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type,
508: c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
509: c_effective_date ben_pgm_f.effective_start_date%type) is
510: SELECT 1
511: FROM ben_prtt_enrt_rslt_f

Line 508: c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,

504: AND pgm.business_group_id = c_business_group_id
505: AND c_effective_date between effective_start_date and effective_end_date;
506:
507: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type,
508: c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
509: c_effective_date ben_pgm_f.effective_start_date%type) is
510: SELECT 1
511: FROM ben_prtt_enrt_rslt_f
512: WHERE person_id = c_person_id

Line 511: FROM ben_prtt_enrt_rslt_f

507: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type,
508: c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
509: c_effective_date ben_pgm_f.effective_start_date%type) is
510: SELECT 1
511: FROM ben_prtt_enrt_rslt_f
512: WHERE person_id = c_person_id
513: AND pgm_id = c_pgm_id
514: AND prtt_enrt_rslt_stat_cd IS NULL
515: AND c_effective_date between effective_start_date and effective_end_date;