APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 795: FROM PO_REQUISITION_LINES_ALL PRL

791: ) -- ADDED AMOUNT condition for Bug7497877 commented this for bug8297942*/
792: AND nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') --Added CLOSED status:Bug#6142700
793: UNION ALL
794: SELECT 1
795: FROM PO_REQUISITION_LINES_ALL PRL
796: WHERE PRL.WIP_ENTITY_ID = l_wip_entity_id
797: AND PRL.DESTINATION_ORGANIZATION_ID = l_organization_id
798: AND nvl(PRL.cancel_flag, 'N') = 'N'
799: AND PRL.LINE_LOCATION_ID is NULL

Line 1218: FROM PO_REQUISITION_LINES_ALL PRL,

1214: ) RETURN BOOLEAN IS
1215:
1216: CURSOR disc_check_po_req_cur IS
1217: SELECT 'PO/REQ Linked'
1218: FROM PO_REQUISITION_LINES_ALL PRL,
1219: PO_REQUISITION_HEADERS_ALL PRH
1220: WHERE PRL.requisition_header_id = PRH.requisition_header_id(+)
1221: AND upper(NVL(PRH.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
1222: AND PRL.WIP_ENTITY_ID = p_wip_entity_id