DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 177: from hr_organization_units

173: */
174:
175: CURSOR get_internal_loc(p_organization_id number) IS
176: select location_id
177: from hr_organization_units
178: where organization_id = p_organization_id;
179:
180:
181: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type,

Line 540: , hr_organization_units hou

536: INTO l_poo_party_id
537: , l_poo_location_id
538: FROM RA_SALESREPS_ALL sales
539: , PER_ALL_ASSIGNMENTS_F ASGN
540: , hr_organization_units hou
541: WHERE ASGN.PERSON_ID = sales.PERSON_ID
542: AND sales.salesrep_id = l_line_rec.salesrep_id
543: AND sales.org_id = l_header_org_id
544: AND NVL(ASGN.PRIMARY_FLAG, 'Y') = 'Y'