APPS.GMF_VIB dependencies on DUAL

Line 467: SELECT c_batchstep_id FROM DUAL;

463: batch_id = c_batch_id
464: START WITH batchstep_id = c_batchstep_id
465: CONNECT BY PRIOR dep_step_id = batchstep_id
466: UNION
467: SELECT c_batchstep_id FROM DUAL;
468:
469: CURSOR c_total_prod_alloc (c_batch_id NUMBER) IS
470: SELECT ing_material_detail_id, batchstep_resource_id,
471: SUM(derived_cost_alloc) total_prod_alloc

Line 1990: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;

1986:
1987: BEGIN
1988:
1989: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
1990: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
1991:
1992:
1993: INSERT INTO gmf_incoming_material_layers(
1994: layer_id,

Line 2174: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;

2170: -- End bug 5607069
2171:
2172: IF l_pseudo_prod_layer_id IS NULL THEN
2173: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2174: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2175:
2176: INSERT INTO gmf_incoming_material_layers(
2177: layer_id,
2178: mmt_transaction_id,

Line 2365: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;

2361:
2362: IF l_pseudo_prod_layer_id IS NULL THEN
2363: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2364: -- Bug 6887598 mmt_organization_id should not be NULL
2365: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2366: INSERT INTO gmf_incoming_material_layers(
2367: layer_id,
2368: mmt_transaction_id,
2369: mmt_organization_id, -- B6887598