APPS.GHR_CORR_CANC_SF52 dependencies on BEN_PGM_F

Line 6310: Cursor c_get_pgm_id(c_prog_name ben_pgm_f.name%type,

6306: where person_id = c_person_id
6307: and c_effective_date between effective_start_date
6308: and effective_end_date;
6309:
6310: Cursor c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
6311: c_business_group_id ben_pgm_f.business_group_id%type,
6312: c_effective_date ben_pgm_f.effective_start_date%type)
6313: is
6314: select pgm.pgm_id

Line 6311: c_business_group_id ben_pgm_f.business_group_id%type,

6307: and c_effective_date between effective_start_date
6308: and effective_end_date;
6309:
6310: Cursor c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
6311: c_business_group_id ben_pgm_f.business_group_id%type,
6312: c_effective_date ben_pgm_f.effective_start_date%type)
6313: is
6314: select pgm.pgm_id
6315: from ben_pgm_f pgm

Line 6312: c_effective_date ben_pgm_f.effective_start_date%type)

6308: and effective_end_date;
6309:
6310: Cursor c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
6311: c_business_group_id ben_pgm_f.business_group_id%type,
6312: c_effective_date ben_pgm_f.effective_start_date%type)
6313: is
6314: select pgm.pgm_id
6315: from ben_pgm_f pgm
6316: where pgm.name = c_prog_name

Line 6315: from ben_pgm_f pgm

6311: c_business_group_id ben_pgm_f.business_group_id%type,
6312: c_effective_date ben_pgm_f.effective_start_date%type)
6313: is
6314: select pgm.pgm_id
6315: from ben_pgm_f pgm
6316: where pgm.name = c_prog_name
6317: and pgm.business_group_id = c_business_group_id
6318: and c_effective_date between effective_start_date and effective_end_date;
6319:

Line 6321: p_pgm_id ben_pgm_f.pgm_id%type,

6317: and pgm.business_group_id = c_business_group_id
6318: and c_effective_date between effective_start_date and effective_end_date;
6319:
6320: Cursor c_get_enrt_rslt(p_person_id per_all_people_f.person_id%type,
6321: p_pgm_id ben_pgm_f.pgm_id%type,
6322: p_per_in_ler_id ben_per_in_ler.per_in_ler_id%type,
6323: p_effective_date date)
6324: is
6325: select prtt_enrt_rslt_id,