APPS.INVPVDR6 dependencies on HR_ORGANIZATION_INFORMATION

Line 70: Table hr_organization_information is used instead of org_organization_defintions*/

66: --4195218 : Changed query for TAX_CODE
67: /* Fix for bug 6350384- Tax Codes are stored at O.U level, so modified below cursor
68: to add a subquery for fetching operating_unit */
69: /*Bug 7437620 Modified the query to fetch the operating unit
70: Table hr_organization_information is used instead of org_organization_defintions*/
71:
72: CURSOR c_tax_code_exists(cp_tax_code VARCHAR2, cp_org_id NUMBER) IS
73: SELECT 'x'
74: FROM ZX_OUTPUT_CLASSIFICATIONS_V

Line 78: AND org_id IN (-99,(SELECT org_information3 FROM hr_organization_information

74: FROM ZX_OUTPUT_CLASSIFICATIONS_V
75: WHERE lookup_code = cp_tax_code
76: AND enabled_flag = 'Y'
77: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
78: AND org_id IN (-99,(SELECT org_information3 FROM hr_organization_information
79: WHERE ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
80: AND ORGANIZATION_ID=cp_org_id));
81:
82: --Start 6531903:Default catalog to be run only once

Line 715: from hr_organization_information

711:
712: if (cr.INVENTORY_PLANNING_CODE = 7) then
713: begin
714: select 'x' into temp
715: from hr_organization_information
716: where org_information_context = 'Customer/Supplier Association'
717: and (org_information1 is not null or org_information3 is not null)
718: and organization_id = cr.organization_id;
719: exception