APPS.OKC_ARTICLES_IMPORT_GRP dependencies on HR_ORGANIZATION_UNITS

Line 199: hr_organization_units hr

195: SELECT a.interface_id,a.entity,error_description,
196: b.article_title,b.article_number,
197: hr.name org_name
198: from okc_art_int_errors a,okc_art_interface_all b,
199: hr_organization_units hr
200: where a.interface_id = b.interface_id
201: and b.org_id = hr.organization_id
202: and b.batch_number = p_batch_number
203: and a.batch_process_id = p_batch_procs_id

Line 242: hr_organization_units hr

238: SELECT a.interface_id,a.entity,error_description,
239: b.source_article_title,b.target_article_title,relationship_type,
240: hr.name org_name
241: from okc_art_int_errors a,okc_art_rels_interface b,
242: hr_organization_units hr
243: where a.interface_id = b.interface_id
244: and b.batch_number = p_batch_number
245: and a.batch_process_id = p_batch_procs_id
246: and b.org_id = hr.organization_id

Line 434: fnd_lookups f,fnd_lookups f1,fnd_lookups f2,hr_organization_units hr

430: f.meaning validate_meaning,
431: nvl(f1.meaning,' ') global_flag_meaning,
432: nvl(f2.meaning,' ') status_meaning
433: FROM OKC_ART_INT_BATPROCS_ALL a,
434: fnd_lookups f,fnd_lookups f1,fnd_lookups f2,hr_organization_units hr
435: WHERE a.validate_only_yn = f.lookup_code
436: and f.lookup_type = 'OKC_YN'
437: and a.global_flag = f1.lookup_code (+)
438: and f1.lookup_type (+)= 'OKC_YN'

Line 541: FROM okc_art_interface_all a,hr_organization_units hr

537: l_check_access VARCHAR2(1);
538:
539: Cursor Pur_org_csr IS
540: SELECT DISTINCT a.org_id org_id,nvl(hr.name,' ') org_name
541: FROM okc_art_interface_all a,hr_organization_units hr
542: WHERE a.org_id IS NOT NULL
543: AND batch_number = p_batch_number
544: AND a.org_id = hr.organization_id(+)
545: UNION ALL

Line 547: FROM okc_art_rels_interface a,hr_organization_units hr

543: AND batch_number = p_batch_number
544: AND a.org_id = hr.organization_id(+)
545: UNION ALL
546: SELECT DISTINCT a.org_id org_id,nvl(hr.name,' ') org_name
547: FROM okc_art_rels_interface a,hr_organization_units hr
548: WHERE a.org_id IS NOT NULL
549: AND batch_number = p_batch_number
550: AND a.org_id = hr.organization_id(+)
551: AND NOT EXISTS

Line 762: FROM okc_art_interface_all a,hr_organization_units hr

758: l_check_access VARCHAR2(1);
759:
760: Cursor Org_csr IS
761: SELECT DISTINCT a.org_id org_id,nvl(hr.name,' ') org_name
762: FROM okc_art_interface_all a,hr_organization_units hr
763: WHERE a.org_id IS NOT NULL
764: AND batch_number = p_batch_number
765: AND a.org_id = hr.organization_id(+)
766: UNION ALL

Line 768: FROM okc_art_rels_interface a,hr_organization_units hr

764: AND batch_number = p_batch_number
765: AND a.org_id = hr.organization_id(+)
766: UNION ALL
767: SELECT DISTINCT a.org_id org_id,nvl(hr.name,' ') org_name
768: FROM okc_art_rels_interface a,hr_organization_units hr
769: WHERE a.org_id IS NOT NULL
770: AND batch_number = p_batch_number
771: AND a.org_id = hr.organization_id(+)
772: AND NOT EXISTS

Line 1653: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;

1649: l_batch_process_id NUMBER;
1650: l_validate_meaning VARCHAR2(80);
1651: l_entity_meaning VARCHAR2(80);
1652: l_entity VARCHAR2(30);
1653: l_org_name HR_ORGANIZATION_UNITS.NAME%TYPE;
1654: l_tot_rows_processed NUMBER;
1655: l_tot_rows_failed NUMBER;
1656: l_tot_rows_warned NUMBER;
1657:

Line 1665: FROM HR_ORGANIZATION_UNITS

1661: WHERE lookup_type = 'OKC_YN' and lookup_code = cp_code;
1662:
1663: CURSOR org_name_csr (cp_org_id IN NUMBER) IS
1664: SELECT NAME
1665: FROM HR_ORGANIZATION_UNITS
1666: WHERE ORGANIZATION_ID = cp_org_id;
1667:
1668: CURSOR entity_meaning_csr (cp_ent_code IN VARCHAR2) IS
1669: SELECT meaning

Line 5985: FROM HR_ORGANIZATION_INFORMATION_V orgi, HR_ORGANIZATION_UNITS_V orgu

5981: AND relationship_type = cp_rel_type;
5982:
5983: CURSOR l_org_valid_csr (cp_org_id IN NUMBER) IS
5984: SELECT '1'
5985: FROM HR_ORGANIZATION_INFORMATION_V orgi, HR_ORGANIZATION_UNITS_V orgu
5986: WHERE orgi.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
5987: AND orgi.organization_id = orgu.organization_id
5988: AND orgi.organization_id = cp_org_id;
5989: