APPS.GHR_SF52_UPDATE dependencies on BEN_PGM_F

Line 491: l_pgm_id ben_pgm_f.pgm_id%type;

487: l_effective_start_date date;
488: l_effective_end_date date;
489: l_delete_warning boolean;
490: l_exists BOOLEAN := FALSE;
491: l_pgm_id ben_pgm_f.pgm_id%type;
492:
493: -- Cursor to get Program
494: CURSOR c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
495: c_business_group_id ben_pgm_f.business_group_id%type,

Line 494: CURSOR c_get_pgm_id(c_prog_name ben_pgm_f.name%type,

490: l_exists BOOLEAN := FALSE;
491: l_pgm_id ben_pgm_f.pgm_id%type;
492:
493: -- Cursor to get Program
494: CURSOR c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
495: c_business_group_id ben_pgm_f.business_group_id%type,
496: c_effective_date ben_pgm_f.effective_start_date%type) is
497: SELECT pgm.pgm_id
498: FROM ben_pgm_f pgm

Line 495: c_business_group_id ben_pgm_f.business_group_id%type,

491: l_pgm_id ben_pgm_f.pgm_id%type;
492:
493: -- Cursor to get Program
494: CURSOR c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
495: c_business_group_id ben_pgm_f.business_group_id%type,
496: c_effective_date ben_pgm_f.effective_start_date%type) is
497: SELECT pgm.pgm_id
498: FROM ben_pgm_f pgm
499: WHERE pgm.name = c_prog_name

Line 496: c_effective_date ben_pgm_f.effective_start_date%type) is

492:
493: -- Cursor to get Program
494: CURSOR c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
495: c_business_group_id ben_pgm_f.business_group_id%type,
496: c_effective_date ben_pgm_f.effective_start_date%type) is
497: SELECT pgm.pgm_id
498: FROM ben_pgm_f pgm
499: WHERE pgm.name = c_prog_name
500: AND pgm.business_group_id = c_business_group_id

Line 498: FROM ben_pgm_f pgm

494: CURSOR c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
495: c_business_group_id ben_pgm_f.business_group_id%type,
496: c_effective_date ben_pgm_f.effective_start_date%type) is
497: SELECT pgm.pgm_id
498: FROM ben_pgm_f pgm
499: WHERE pgm.name = c_prog_name
500: AND pgm.business_group_id = c_business_group_id
501: AND c_effective_date between effective_start_date and effective_end_date;
502:

Line 505: c_effective_date ben_pgm_f.effective_start_date%type) is

501: AND c_effective_date between effective_start_date and effective_end_date;
502:
503: CURSOR c_emp_in_ben(c_person_id ben_prtt_enrt_rslt_f.person_id%type,
504: c_pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
505: c_effective_date ben_pgm_f.effective_start_date%type) is
506: SELECT 1
507: FROM ben_prtt_enrt_rslt_f
508: WHERE person_id = c_person_id
509: AND pgm_id = c_pgm_id