DBA Data[Home] [Help]

APPS.PQH_FR_CR_PATH_ENGINE_PKG dependencies on BEN_PGM_F

Line 229: select * from ben_pgm_f pgm

225:
226: l_pgm_row ben_cobj_cache.g_pgm_inst_row;
227:
228: Cursor pgm_info is
229: select * from ben_pgm_f pgm
230: where pgm_id = p_pgm_id
231: and p_effective_date between pgm.effective_start_date and pgm.effective_end_date;
232:
233: pgm_info_rec pgm_info%rowtype;

Line 336: from ben_pgm_f

332: hr_utility.set_location('Creating electable choice ',5);
333:
334: select enrt_mthd_cd
335: into l_posting_style
336: from ben_pgm_f
337: where pgm_id = p_pgm_id
338: and p_effective_date between effective_start_date and effective_end_date;
339:
340:

Line 686: ben_pgm_f pgm,

682: ghn.Information13 req_days
683: from PER_GEN_HIERARCHY_NODES ghn,
684: ben_pl_f pl,
685: pqh_corps_definitions corp,
686: ben_pgm_f pgm,
687: ben_plip_f plip,
688: ben_ptip_f ptip
689: where ghn.Information4 = l_cur_corp_id --cur_corp_id
690: --and ghn.Information30 = l_cur_grade_id -- cur_pgm_id