APPS.GHR_CORR_CANC_SF52 dependencies on BEN_PGM_F

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

5953: where person_id = c_person_id
5954: and c_effective_date between effective_start_date
5955: and effective_end_date;
5956:
5957: Cursor c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
5958: c_business_group_id ben_pgm_f.business_group_id%type,
5959: c_effective_date ben_pgm_f.effective_start_date%type)
5960: is
5961: select pgm.pgm_id

Line 5958: c_business_group_id ben_pgm_f.business_group_id%type,

5954: and c_effective_date between effective_start_date
5955: and effective_end_date;
5956:
5957: Cursor c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
5958: c_business_group_id ben_pgm_f.business_group_id%type,
5959: c_effective_date ben_pgm_f.effective_start_date%type)
5960: is
5961: select pgm.pgm_id
5962: from ben_pgm_f pgm

Line 5959: c_effective_date ben_pgm_f.effective_start_date%type)

5955: and effective_end_date;
5956:
5957: Cursor c_get_pgm_id(c_prog_name ben_pgm_f.name%type,
5958: c_business_group_id ben_pgm_f.business_group_id%type,
5959: c_effective_date ben_pgm_f.effective_start_date%type)
5960: is
5961: select pgm.pgm_id
5962: from ben_pgm_f pgm
5963: where pgm.name = c_prog_name

Line 5962: from ben_pgm_f pgm

5958: c_business_group_id ben_pgm_f.business_group_id%type,
5959: c_effective_date ben_pgm_f.effective_start_date%type)
5960: is
5961: select pgm.pgm_id
5962: from ben_pgm_f pgm
5963: where pgm.name = c_prog_name
5964: and pgm.business_group_id = c_business_group_id
5965: and c_effective_date between effective_start_date and effective_end_date;
5966:

Line 5968: p_pgm_id ben_pgm_f.pgm_id%type,

5964: and pgm.business_group_id = c_business_group_id
5965: and c_effective_date between effective_start_date and effective_end_date;
5966:
5967: Cursor c_get_enrt_rslt(p_person_id per_all_people_f.person_id%type,
5968: p_pgm_id ben_pgm_f.pgm_id%type,
5969: p_per_in_ler_id ben_per_in_ler.per_in_ler_id%type,
5970: p_effective_date date)
5971: is
5972: select prtt_enrt_rslt_id,