[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