APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 30: FROM HR_ALL_ORGANIZATION_UNITS_TL htl

26:
27: CURSOR c_org_name_csr( p_org_id NUMBER, p_ledger_lang VARCHAR2 )
28: IS
29: SELECT htl.NAME org_name
30: FROM HR_ALL_ORGANIZATION_UNITS_TL htl
31: WHERE htl.organization_id = p_org_id
32: AND htl.LANGUAGE = p_ledger_lang;
33: CURSOR c_org_name_code_csr( p_org_id NUMBER )
34: IS

Line 36: FROM hr_all_organization_units ht

32: AND htl.LANGUAGE = p_ledger_lang;
33: CURSOR c_org_name_code_csr( p_org_id NUMBER )
34: IS
35: SELECT ht.NAME org_name
36: FROM hr_all_organization_units ht
37: WHERE ht.organization_id = p_org_id;
38:
39: -- Cursor to fetch basic Contract Attributes
40: CURSOR c_khr_attributes_csr (l_khr_id NUMBER)

Line 60: ,hr_all_organization_units hr_org

56: ,khr.pdt_id pdt_id
57: ,chr.scs_code scs_code
58: FROM okc_k_headers_all_b chr
59: ,okl_k_headers khr
60: ,hr_all_organization_units hr_org
61: WHERE khr.id = l_khr_id
62: AND chr.id = khr.id
63: AND hr_org.organization_id = chr.authoring_org_id;
64:

Line 358: ,hr_all_organization_units hrb

354: IS
355: SELECT khr.inv_organization_id inv_organization_id
356: ,hrb.NAME hrb_name
357: FROM okc_k_headers_all_b khr
358: ,hr_all_organization_units hrb
359: WHERE khr.id = p_khr_id
360: AND hrb.organization_id = khr.inv_organization_id;
361:
362: CURSOR c_khr_to_ledger_id_csr( p_khr_id NUMBER )