DBA Data[Home] [Help]

APPS.PQH_FR_CR_PATH_ENGINE_PKG dependencies on PQH_CORPS_DEFINITIONS

Line 685: pqh_corps_definitions corp,

681: ghn.Information12 req_Months,
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

Line 967: pqh_corps_definitions corp

963: per_spinal_point_steps_f sps,
964: ben_opt_f opt,
965: ben_oipl_f oipl,
966: ben_pl_f pl,
967: pqh_corps_definitions corp
968: where asg.person_id = l_pil_info_rec.person_id
969: and asg.primary_flag = 'Y'
970: and asg.business_group_id = l_pil_info_rec.business_group_id
971: and asg.assignment_status_type_id = 1