DBA Data[Home] [Help]

APPS.AHL_PRD_UTIL_PKG dependencies on AHL_WORKORDER_OPERATIONS_V

Line 1532: FROM AHL_WORKORDER_OPERATIONS_V AO

1528: -- query to retrieve min of assigned to all employees for an operation.
1529: CURSOR c_get_op_sched_start(p_workorder_id IN NUMBER,
1530: p_operation_seq_num IN NUMBER) IS
1531: SELECT SCHEDULED_START_DATE
1532: FROM AHL_WORKORDER_OPERATIONS_V AO
1533: WHERE AO.workorder_id = p_workorder_id
1534: AND AO.operation_sequence_num = p_operation_seq_num;
1535:
1536: l_employee_id NUMBER;

Line 1615: FROM AHL_WORKORDER_OPERATIONS_V AO

1611: -- query to retrieve min of assigned to all employees for an operation.
1612: CURSOR c_get_op_sched_end(p_workorder_id IN NUMBER,
1613: p_operation_seq_num IN NUMBER) IS
1614: SELECT SCHEDULED_END_DATE
1615: FROM AHL_WORKORDER_OPERATIONS_V AO
1616: WHERE AO.workorder_id = p_workorder_id
1617: AND AO.operation_sequence_num = p_operation_seq_num;
1618:
1619: l_employee_id NUMBER;