DBA Data[Home] [Help]

APPS.PQH_FR_CR_PATH_ENGINE_PKG dependencies on BEN_OIPL_F

Line 717: , ben_oipl_f oipl

713: oipl.oipl_id to_oipl_id
714: from
715: per_spinal_point_steps_f sps
716: , ben_opt_f opt
717: , ben_oipl_f oipl
718: where sps.step_id = career_path_rec.to_step_id
719: and opt.mapping_table_name = 'PER_SPINAL_POINTS'
720: and opt.mapping_table_pk_id = sps.spinal_point_id
721: and oipl.opt_id = opt.opt_id

Line 965: ben_oipl_f oipl,

961: from per_all_assignments_f asg,
962: per_spinal_point_placements_f spp,
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'