DBA Data[Home] [Help]

APPS.HR_HEAD_COUNT dependencies on PER_REQUISITIONS

Line 562: ,per_requisitions req

558: select vac.job_id,
559: vac.BUDGET_MEASUREMENT_VALUE,
560: vac.NUMBER_OF_OPENINGS
561: from per_vacancies vac
562: ,per_requisitions req
563: where vac.organization_id = P_ORGANIZATION_ID_CHILD
564: --and vac.business_group_id = P_BUSINESS_GROUP_ID
565: and vac.BUDGET_MEASUREMENT_TYPE = P_BUDGET
566: and vac.REQUISITION_ID = req.REQUISITION_ID