DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 265: hr_all_organization_units o

261:
262: CURSOR csr_vendor_name IS
263: SELECT o.NAME AS vendor_name
264: FROM okc_k_party_roles_b r,
265: hr_all_organization_units o
266: WHERE o.organization_id = r.object1_id1
267: AND r.jtot_object1_code = 'OKX_OPERUNIT'
268: AND r.rle_code IN
269: ('VENDOR', 'MERCHANT') -- gets only the VENDOR / MERCHANT

Line 416: hr_all_organization_units o

412:
413: CURSOR csr_vendor_name IS
414: SELECT o.NAME AS vendor_name
415: FROM okc_k_party_roles_b r,
416: hr_all_organization_units o
417: WHERE o.organization_id = r.object1_id1
418: AND r.jtot_object1_code = 'OKX_OPERUNIT'
419: AND r.rle_code IN
420: ('VENDOR', 'MERCHANT') -- gets only the VENDOR / MERCHANT

Line 552: hr_all_organization_units o

548:
549: CURSOR csr_vendor_name IS
550: SELECT o.NAME AS vendor_name
551: FROM okc_k_party_roles_b r,
552: hr_all_organization_units o
553: WHERE o.organization_id = r.object1_id1
554: AND r.jtot_object1_code = 'OKX_OPERUNIT'
555: AND r.rle_code = 'VENDOR' -- gets only the VENDOR
556: AND r.cle_id IS NULL