DBA Data[Home] [Help]

APPS.PA_PARCPRJR_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 93: HR_ALL_ORGANIZATION_UNITS HRORG

89: INTO CP_COUNT
90: FROM
91: PA_RESOURCES RES,
92: PA_RESOURCES_DENORM OU,
93: HR_ALL_ORGANIZATION_UNITS HRORG
94: WHERE RES.RESOURCE_ID = OU.RESOURCE_ID
95: AND HRORG.ORGANIZATION_ID = OU.RESOURCE_ORGANIZATION_ID
96: AND ( DECODE(RES.REQUEST_ID
97: ,P_CONC_REQUEST_ID