[Home] [Help]
104: UNION ALL
105: SELECT
106: PRI.WIP_ENTITY_ID
107: FROM
108: PO_REQUISITIONS_INTERFACE_ALL PRI
109: WHERE PRI.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID );
110: RETURN 1;
111: END QR_PTXN_JOBREFCURDS;
112:
363: OR exists (
364: SELECT
365: 1
366: FROM
367: PO_REQUISITIONS_INTERFACE_ALL PRI
368: WHERE PRI.DESTINATION_ORGANIZATION_ID = P_ORGANIZATION_ID
369: AND PRI.WIP_ENTITY_ID = WIP_ENTITY_ID_1 );
370: EXCEPTION
371: WHEN NO_DATA_FOUND THEN