APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on DUAL

Line 1225: SELECT 1 FROM dual

1221: )
1222: IS
1223: -- Check to see Operation Resource Id exists
1224: CURSOR Sch_id_exists (x_id IN NUMBER) IS
1225: SELECT 1 FROM dual
1226: WHERE EXISTS (SELECT 1
1227: FROM AHL_OPERATION_RESOURCES
1228: WHERE OPERATION_RESOURCE_ID = x_id);
1229:

Line 2103: FROM DUAL;

2099: --
2100: -- Get Sequence Number for Resource Requirement ID
2101: SELECT AHL_OPERATION_RESOURCES_S.NEXTVAL
2102: INTO l_Resrc_Require_Rec.Operation_Resource_id
2103: FROM DUAL;
2104:
2105: --Check for Record Exists
2106: OPEN Sch_id_exists(l_Requirement_id);
2107: FETCH Sch_id_exists INTO l_dummy;

Line 2167: FROM DUAL;

2163: END IF;
2164:
2165: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL
2166: INTO l_wo_operation_txn_id
2167: FROM DUAL;
2168: IF G_DEBUG='Y' THEN
2169: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
2170: END IF;
2171:

Line 3106: FROM DUAL;

3102: p_x_resrc_Require_tbl(i) := l_Resrc_Require_Rec;
3103: --Get the value from sequence
3104: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL
3105: INTO l_wo_operation_txn_id
3106: FROM DUAL;
3107: IF G_DEBUG='Y' THEN
3108: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
3109: END IF;
3110: -- Create Record in transactions table

Line 3621: SELECT 'x' FROM DUAL

3617: p_organization_id IN NUMBER,
3618: p_op_seq IN NUMBER,
3619: p_res_seq IN NUMBER)
3620: IS
3621: SELECT 'x' FROM DUAL
3622: WHERE EXISTS ( SELECT 'x'
3623: FROM WIP_TRANSACTIONS
3624: WHERE wip_entity_id = p_wip_entity_id
3625: AND organization_id = p_organization_id