DBA Data[Home] [Help]

APPS.PQH_FR_CR_PATH_ENGINE_PKG dependencies on BEN_LEE_RSN_F

Line 295: from ben_lee_rsn_f blr,

291: hr_utility.set_location('Geting P_Enrt_Cvg_Strt_Dt ',5);
292:
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

Line 577: from ben_lee_rsn_f blr,

573: if l_number_of_rows > 0 then
574:
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