APPS.PQH_FR_CR_PATH_ENGINE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 77: l_empasg_row per_all_assignments_f%ROWTYPE;

73: l_return_status varchar2(1);
74: l_elig_return_status boolean;
75: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
76: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
77: l_empasg_row per_all_assignments_f%ROWTYPE;
78: l_benasg_row per_all_assignments_f%ROWTYPE;
79: l_pil_row ben_per_in_ler%ROWTYPE;
80: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
81: l_score_tab ben_evaluate_elig_profiles.scoreTab;

Line 78: l_benasg_row per_all_assignments_f%ROWTYPE;

74: l_elig_return_status boolean;
75: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
76: l_comp_obj_tree_row ben_manage_life_events.g_cache_proc_objects_rec;
77: l_empasg_row per_all_assignments_f%ROWTYPE;
78: l_benasg_row per_all_assignments_f%ROWTYPE;
79: l_pil_row ben_per_in_ler%ROWTYPE;
80: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
81: l_score_tab ben_evaluate_elig_profiles.scoreTab;
82:

Line 961: from per_all_assignments_f asg,

957: spp.step_id cur_step_id,
958: asg.grade_ladder_pgm_id cur_pgm_id,
959: pl.pl_id cur_plan_id,
960: oipl.oipl_id cur_oipl_id
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,