APPS.AHL_COMPLETIONS_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 606: FROM AHL_WORKORDER_MTL_TXNS TXN, AHL_WORKORDER_OPERATIONS OP

602:
603: CURSOR get_ahl_txn_rec( c_workorder_id NUMBER )
604: IS
605: SELECT MAX ( TXN.creation_date )
606: FROM AHL_WORKORDER_MTL_TXNS TXN, AHL_WORKORDER_OPERATIONS OP
607: WHERE TXN.workorder_operation_id = OP.workorder_operation_id
608: AND OP.workorder_id = c_workorder_id;
609: BEGIN
610:

Line 1003: FROM AHL_WORKORDER_MTL_TXNS

999:
1000: CURSOR get_ahl_txn_rec( c_workorder_operation_id NUMBER )
1001: IS
1002: SELECT MAX ( creation_date )
1003: FROM AHL_WORKORDER_MTL_TXNS
1004: WHERE workorder_operation_id = c_workorder_operation_id;
1005: BEGIN
1006:
1007: OPEN get_ahl_txn_rec( p_workorder_operation_id );