DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 632: FROM AHL_WORKORDER_MTL_TXNS TXN, AHL_WORKORDER_OPERATIONS OP

628:
629: CURSOR get_ahl_txn_rec( c_workorder_id NUMBER )
630: IS
631: SELECT MAX ( TXN.creation_date )
632: FROM AHL_WORKORDER_MTL_TXNS TXN, AHL_WORKORDER_OPERATIONS OP
633: WHERE TXN.workorder_operation_id = OP.workorder_operation_id
634: AND OP.workorder_id = c_workorder_id;
635: BEGIN
636:

Line 1042: FROM AHL_WORKORDER_MTL_TXNS

1038:
1039: CURSOR get_ahl_txn_rec( c_workorder_operation_id NUMBER )
1040: IS
1041: SELECT MAX ( creation_date )
1042: FROM AHL_WORKORDER_MTL_TXNS
1043: WHERE workorder_operation_id = c_workorder_operation_id;
1044: BEGIN
1045:
1046: OPEN get_ahl_txn_rec( p_workorder_operation_id );