DBA Data[Home] [Help]

APPS.OKC_CA_UTIL_PVT dependencies on HR_OPERATING_UNITS

Line 237: hr_operating_units orgu

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,
241: ( select

Line 287: hr_operating_units orgu

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,
291: ( select

Line 393: hr_operating_units orgu

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
397: where article_srch_id = p_search_id

Line 472: hr_operating_units orgu

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
476: where t.article_srch_id = p_search_id

Line 500: hr_operating_units orgu

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
504: where t.article_srch_id = p_search_id

Line 586: hr_operating_units orgu

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
590: where a.article_id = v.article_id