APPS.AHL_CMP_PVT dependencies on DUAL

Line 895: FROM DUAL;

891:
892: IF(p_x_txn_hdr_id IS NULL) THEN
893: SELECT Mtl_Material_Transactions_S.nextval
894: INTO p_x_txn_hdr_id
895: FROM DUAL;
896: IF G_DEBUG='Y' THEN
897: AHL_DEBUG_PUB.debug('Header id created..['||p_x_txn_hdr_id||']');
898: END IF;
899: END IF;

Line 907: FROM DUAL;

903: IF ( p_x_ahl_mtlxfr_rec.Quantity > 0) THEN
904:
905: SELECT Mtl_Material_Transactions_S.nextval
906: INTO p_x_txn_intf_id
907: FROM DUAL;
908:
909: IF G_DEBUG='Y' THEN
910: AHL_DEBUG_PUB.debug('Interface id created..['||p_x_txn_intf_id||']');
911: END IF;

Line 955: FROM DUAL;

951:
952: IF(p_x_ahl_mtlxfr_rec.Serial_Number IS NOT NULL) THEN
953: SELECT Mtl_Material_Transactions_S.nextval
954: INTO l_txn_tmp_id
955: FROM DUAL;
956: ELSE
957: l_txn_tmp_id := p_x_txn_intf_id;
958: END IF;
959: