APPS.AHL_PRD_UTIL_PKG dependencies on AHL_WORKORDER_OPERATIONS_V

Line 1508: FROM AHL_WORKORDER_OPERATIONS_V AO

1504: -- query to retrieve min of assigned to all employees for an operation.
1505: CURSOR c_get_op_sched_start(p_workorder_id IN NUMBER,
1506: p_operation_seq_num IN NUMBER) IS
1507: SELECT SCHEDULED_START_DATE
1508: FROM AHL_WORKORDER_OPERATIONS_V AO
1509: WHERE AO.workorder_id = p_workorder_id
1510: AND AO.operation_sequence_num = p_operation_seq_num;
1511:
1512: l_employee_id NUMBER;

Line 1591: FROM AHL_WORKORDER_OPERATIONS_V AO

1587: -- query to retrieve min of assigned to all employees for an operation.
1588: CURSOR c_get_op_sched_end(p_workorder_id IN NUMBER,
1589: p_operation_seq_num IN NUMBER) IS
1590: SELECT SCHEDULED_END_DATE
1591: FROM AHL_WORKORDER_OPERATIONS_V AO
1592: WHERE AO.workorder_id = p_workorder_id
1593: AND AO.operation_sequence_num = p_operation_seq_num;
1594:
1595: l_employee_id NUMBER;