APPS.GMF_VIB dependencies on DUAL

Line 468: SELECT c_batchstep_id dep_step_id FROM DUAL;

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

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

2049:
2050: BEGIN
2051:
2052: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2053: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2054:
2055:
2056: INSERT INTO gmf_incoming_material_layers(
2057: layer_id,

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

2233: -- End bug 5607069
2234:
2235: IF l_pseudo_prod_layer_id IS NULL THEN
2236: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2237: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2238:
2239: INSERT INTO gmf_incoming_material_layers(
2240: layer_id,
2241: mmt_transaction_id,

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

2424:
2425: IF l_pseudo_prod_layer_id IS NULL THEN
2426: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2427: -- Bug 6887598 mmt_organization_id should not be NULL
2428: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2429: INSERT INTO gmf_incoming_material_layers(
2430: layer_id,
2431: mmt_transaction_id,
2432: mmt_organization_id, -- B6887598