APPS.AHL_DI_DOC_REVISION_PVT dependencies on AHL_PC_NODES_B

Line 523: FROM ahl_pc_headers_b header,ahl_pc_nodes_b node

519: --Cursor to get PC status
520: CURSOR get_pc_status(c_node_id NUMBER)
521: IS
522: SELECT STATUS
523: FROM ahl_pc_headers_b header,ahl_pc_nodes_b node
524: WHERE node.pc_node_id = c_node_id
525: AND header.pc_header_id = node.pc_header_id;
526:
527: --Cursor to get MR status