APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 3958: SELECT workorder_operation_id from ahl_workorder_operations

3954: WHERE status_code = p_condition_meaning;
3955:
3956:
3957: CURSOR wo_operation_id_csr(p_workorder_id IN NUMBER, p_operation_seq IN NUMBER) IS
3958: SELECT workorder_operation_id from ahl_workorder_operations
3959: WHERE workorder_id = p_workorder_id AND operation_sequence_num = p_operation_seq;
3960:
3961: CURSOR severity_id_csr(p_severity_name IN VARCHAR2) IS
3962: SELECT incident_severity_id from cs_incident_severities_vl

Line 4472: SELECT 'x' FROM ahl_workorder_operations

4468:
4469: PROCEDURE validate_wo_operation(p_workorder_id IN NUMBER, p_wo_operation_id IN NUMBER) IS
4470:
4471: CURSOR val_wo_operation_csr(p_workorder_id IN NUMBER, p_wo_operation_id IN NUMBER) IS
4472: SELECT 'x' FROM ahl_workorder_operations
4473: WHERE workorder_operation_id = p_wo_operation_id
4474: AND workorder_id = p_workorder_id;
4475:
4476: l_exist VARCHAR(1);