DBA Data[Home] [Help]

APPS.MRP_PARAMETER_MRPEPPS dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 145: SELECT organization_name name, organization_id from org_organization_definitions;

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

Line 295: from org_organization_definitions

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

Line 310: from org_organization_definitions

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