DBA Data[Home] [Help]

APPS.MRP_PARAMETER_MRPEPPS dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 144: SELECT organization_name name, organization_id from org_organization_definitions;

140: where data_completion_date is not null
141: and plan_completion_date is not null;
142:
143: CURSOR c_orgs IS
144: SELECT organization_name name, organization_id from org_organization_definitions;
145:
146: l_return_status VARCHAR2(1000);
147: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
148:

Line 293: from org_organization_definitions

289: end if;
290:
291: select organization_id
292: into l_organization_id
293: from org_organization_definitions
294: where organization_name like P_ORG_NAME;
295:
296: RETURN TRUE;
297:

Line 308: from org_organization_definitions

304: end if;
305:
306: select max(organization_id), count(*)
307: into l_organization_id, l_count
308: from org_organization_definitions
309: where organization_name like P_ORG_NAME AND
310: organization_id = P_ORG_ID;
311:
312: if l_count = 1 then