APPS.OKC_CA_UTIL_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 236: hr_organization_information orgi,

232: ( select
233: orgu.organization_id org_id,
234: orgu.name org_name
235: from
236: hr_organization_information orgi,
237: hr_operating_units orgu
238: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
239: and orgi.organization_id = orgu.organization_id
240: ) org,

Line 286: hr_organization_information orgi,

282: ( select
283: orgu.organization_id org_id,
284: orgu.name org_name
285: from
286: hr_organization_information orgi,
287: hr_operating_units orgu
288: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
289: and orgi.organization_id = orgu.organization_id
290: ) org,

Line 392: hr_organization_information orgi,

388: ( select
389: orgu.organization_id org_id,
390: orgu.name org_name
391: from
392: hr_organization_information orgi,
393: hr_operating_units orgu
394: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
395: and orgi.organization_id = orgu.organization_id
396: ) org

Line 471: hr_organization_information orgi,

467: ( select
468: orgu.organization_id org_id,
469: orgu.name org_name
470: from
471: hr_organization_information orgi,
472: hr_operating_units orgu
473: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
474: and orgi.organization_id = orgu.organization_id
475: ) org

Line 499: hr_organization_information orgi,

495: ( select
496: orgu.organization_id org_id,
497: orgu.name org_name
498: from
499: hr_organization_information orgi,
500: hr_operating_units orgu
501: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
502: and orgi.organization_id = orgu.organization_id
503: ) org

Line 585: hr_organization_information orgi,

581: ( select
582: orgu.organization_id org_id,
583: orgu.name org_name
584: from
585: hr_organization_information orgi,
586: hr_operating_units orgu
587: where orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
588: and orgi.organization_id = orgu.organization_id
589: ) org