APPS.INV_SUB_CG_UTIL dependencies on MTL_PARAMETERS

Line 261: FROM mtl_parameters mp

257: SELECT 'Y' INTO l_cannot_delete FROM dual
258: WHERE
259: exists
260: (SELECT organization_id
261: FROM mtl_parameters mp
262: WHERE mp.default_cost_group_id = p_cost_group_id);
263: EXCEPTION
264: WHEN no_data_found THEN
265: l_cannot_delete := 'N';

Line 333: FROM mtl_parameters mp

329: SELECT 'Y' INTO l_cannot_delete FROM dual
330: WHERE
331: exists
332: (SELECT organization_id
333: FROM mtl_parameters mp
334: WHERE mp.default_cost_group_id = p_cost_group_id
335: AND mp.organization_id = p_organization_id);
336: EXCEPTION
337: WHEN no_data_found THEN

Line 689: update mtl_parameters

685: --
686: -- Update the organization with the cost group's accounts
687: --
688:
689: update mtl_parameters
690: set
691: material_account = l_material_account
692: , material_overhead_account = l_material_overhead_account
693: , resource_account = l_resource_account

Line 876: from mtl_parameters

872: is
873: cursor org_cursor
874: is
875: select organization_id
876: from mtl_parameters
877: where default_cost_group_id = p_cost_group_id;
878:
879: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
880: l_count integer := 0;

Line 966: from mtl_parameters

962: x_return_status := fnd_api.g_ret_sts_success;
963:
964: select nvl(default_cost_group_id,0)
965: into l_cost_group_id
966: from mtl_parameters
967: where organization_id = p_organization_id;
968:
969: return l_cost_group_id;
970: exception