APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 3525: SELECT workorder_operation_id from ahl_workorder_operations

3521: WHERE status_code = p_condition_meaning;
3522:
3523:
3524: CURSOR wo_operation_id_csr(p_workorder_id IN NUMBER, p_operation_seq IN NUMBER) IS
3525: SELECT workorder_operation_id from ahl_workorder_operations
3526: WHERE workorder_id = p_workorder_id AND operation_sequence_num = p_operation_seq;
3527:
3528: CURSOR severity_id_csr(p_severity_name IN VARCHAR2) IS
3529: SELECT incident_severity_id from cs_incident_severities_vl

Line 4012: SELECT 'x' FROM ahl_workorder_operations

4008:
4009: PROCEDURE validate_wo_operation(p_workorder_id IN NUMBER, p_wo_operation_id IN NUMBER) IS
4010:
4011: CURSOR val_wo_operation_csr(p_workorder_id IN NUMBER, p_wo_operation_id IN NUMBER) IS
4012: SELECT 'x' FROM ahl_workorder_operations
4013: WHERE workorder_operation_id = p_wo_operation_id
4014: AND workorder_id = p_workorder_id;
4015:
4016: l_exist VARCHAR(1);