DBA Data[Home] [Help]

APPS.JAI_OPEN_API_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 262: FROM org_organization_definitions

258: IS
259: --Cursor define here
260: CURSOR chk_org_cur IS
261: SELECT COUNT(organization_id)
262: FROM org_organization_definitions
263: WHERE operating_unit = pn_chk_org_id;
264:
265: CURSOR chk_organization_cur IS
266: SELECT COUNT(organization_id)

Line 267: FROM org_organization_definitions

263: WHERE operating_unit = pn_chk_org_id;
264:
265: CURSOR chk_organization_cur IS
266: SELECT COUNT(organization_id)
267: FROM org_organization_definitions
268: WHERE operating_unit = pn_chk_org_id
269: AND organization_id = pn_chk_organization_id;
270:
271: CURSOR chk_loc_cur IS

Line 280: , org_organization_definitions b

276:
277: CURSOR chk_combination_cur IS
278: SELECT COUNT(b.organization_id)
279: FROM jai_cmn_inventory_orgs a
280: , org_organization_definitions b
281: WHERE b.operating_unit = pn_chk_org_id
282: AND a.organization_id = pn_chk_organization_id
283: AND a.location_id = pn_chk_location_id
284: AND a.organization_id = b.organization_id;