DBA Data[Home] [Help]

APPS.INVPVDR6 dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 74: FROM ZX_OUTPUT_CLASSIFICATIONS_V

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
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