APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on DUAL

Line 1047: SELECT 1 FROM dual

1043: )
1044: IS
1045: -- Check to see Operation Resource Id exists
1046: CURSOR Sch_id_exists (x_id IN NUMBER) IS
1047: SELECT 1 FROM dual
1048: WHERE EXISTS (SELECT 1
1049: FROM AHL_OPERATION_RESOURCES
1050: WHERE OPERATION_RESOURCE_ID = x_id);
1051:

Line 1908: FROM DUAL;

1904: --
1905: -- Get Sequence Number for Resource Requirement ID
1906: SELECT AHL_OPERATION_RESOURCES_S.NEXTVAL
1907: INTO l_Resrc_Require_Rec.Operation_Resource_id
1908: FROM DUAL;
1909:
1910: --Check for Record Exists
1911: OPEN Sch_id_exists(l_Requirement_id);
1912: FETCH Sch_id_exists INTO l_dummy;

Line 1969: FROM DUAL;

1965: END IF;
1966:
1967: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL
1968: INTO l_wo_operation_txn_id
1969: FROM DUAL;
1970: IF G_DEBUG='Y' THEN
1971: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
1972: END IF;
1973:

Line 2885: FROM DUAL;

2881: p_x_resrc_Require_tbl(i) := l_Resrc_Require_Rec;
2882: --Get the value from sequence
2883: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL
2884: INTO l_wo_operation_txn_id
2885: FROM DUAL;
2886: IF G_DEBUG='Y' THEN
2887: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
2888: END IF;
2889: -- Create Record in transactions table

Line 3376: SELECT 'x' FROM DUAL

3372: p_organization_id IN NUMBER,
3373: p_op_seq IN NUMBER,
3374: p_res_seq IN NUMBER)
3375: IS
3376: SELECT 'x' FROM DUAL
3377: WHERE EXISTS ( SELECT 'x'
3378: FROM WIP_TRANSACTIONS
3379: WHERE wip_entity_id = p_wip_entity_id
3380: AND organization_id = p_organization_id