DBA Data[Home] [Help]

APPS.PA_PARCPRJR_XMLP_PKG dependencies on PA_RESOURCES

Line 91: PA_RESOURCES RES,

87: SELECT
88: count(*)
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

Line 92: PA_RESOURCES_DENORM OU,

88: count(*)
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