DBA Data[Home] [Help]

APPS.WIP_PENDING_TXNS dependencies on WIP_OPERATION_RESOURCES

Line 42: FROM WIP_OPERATION_RESOURCES

38: SELECT WIP_CONSTANTS.YES
39: INTO P_RESOURCES_CHARGED
40: FROM DUAL
41: WHERE EXISTS (SELECT 'X'
42: FROM WIP_OPERATION_RESOURCES
43: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
44: AND WIP_ENTITY_ID = P_WIP_ENTITY_ID
45: AND APPLIED_RESOURCE_UNITS <> 0);
46: