APPS.AHL_PRD_OPERATIONS_PVT dependencies on AHL_OPERATIONS_VL

Line 48: FROM AHL_OPERATIONS_VL OP

44: IS
45: SELECT OP.operation_id,
46: OP.description,
47: OP.qa_inspection_type
48: FROM AHL_OPERATIONS_VL OP
49: WHERE OP.concatenated_segments=c_operation_code
50: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(OP.start_date_active,SYSDATE))
51: AND TRUNC(NVL(OP.end_date_active,SYSDATE+1))
52: AND OP.revision_status_code='COMPLETE'