APPS.PQH_FR_CR_PATH_ENGINE_PKG dependencies on BEN_PER_IN_LER

Line 79: l_pil_row ben_per_in_ler%ROWTYPE;

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:
83: begin

Line 297: ben_per_in_ler pil

293: select blr.LEE_RSN_ID,pil.request_id
294: into l_LEE_RSN_ID, l_request_id
295: from ben_lee_rsn_f blr,
296: ben_popl_enrt_typ_cycl_f popl,
297: ben_per_in_ler pil
298: where blr.business_group_id = p_business_group_id
299: and blr.popl_enrt_typ_cycl_id = popl.POPL_ENRT_TYP_CYCL_ID
300: and blr.ler_id = pil.ler_id
301: and pil.per_in_ler_id = p_per_in_ler_id

Line 579: ben_per_in_ler pil

575: select pil.request_id
576: into l_request_id
577: from ben_lee_rsn_f blr,
578: ben_popl_enrt_typ_cycl_f popl,
579: ben_per_in_ler pil
580: where blr.business_group_id = p_business_group_id
581: and blr.popl_enrt_typ_cycl_id = popl.POPL_ENRT_TYP_CYCL_ID
582: and blr.ler_id = pil.ler_id
583: and pil.per_in_ler_id = p_per_in_ler_id

Line 948: from ben_per_in_ler

944: is
945:
946: cursor per_in_ler_info is
947: Select *
948: from ben_per_in_ler
949: where per_in_ler_id = p_per_in_ler_id;
950:
951: l_pil_info_rec per_in_ler_info%rowtype;
952: