APPS.MRP_PARAMETER_MRPFSETA dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 33: from org_organization_definitions

29: end if;
30:
31: select max(organization_id), count(organization_name)
32: into l_org_id, l_count
33: from org_organization_definitions
34: where organization_name = P_ORG_NAME;
35: if (l_org_id is NULL) then
36: goto no_org_found;
37: end if;

Line 41: from org_organization_definitions

37: end if;
38: if (l_count > 1) then -- duplicate org name, verify id
39: select 1
40: into l_exist
41: from org_organization_definitions
42: where organization_name = P_ORG_NAME
43: and organization_id = P_ORG_ID;
44: end if;
45:

Line 76: org_organization_definitions org

72: into l_period_type
73: from gl_periods
74: where period_set_name in (select period_set_name
75: from gl_sets_of_books gl,
76: org_organization_definitions org
77: where org.set_of_books_id = gl.set_of_books_id
78: and org.organization_id = p_org_id)
79: and period_type = P_PERIOD;
80: end if;

Line 173: FROM org_organization_definitions

169: -- param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type, --2663505
170: i IN NUMBER) IS
171: CURSOR c_organizations IS
172: SELECT organization_id org_id, organization_name name
173: FROM org_organization_definitions
174: ORDER BY organization_name;
175: BEGIN
176: -- htp.formHidden('p_org_id');
177: /*

Line 333: SELECT organization_name name, organization_id from org_organization_definitions

329: AND organization_id = 207
330: ORDER BY forecast_designator;
331:
332: CURSOR c_orgs IS
333: SELECT organization_name name, organization_id from org_organization_definitions
334: ORDER BY organization_name;
335:
336: l_return_status VARCHAR2(1000);
337: -- l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;