APPS.OM_TAX_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 152: FROM hr_organization_units

148: AND party_site_ship.location_id = loc_ship.location_id;
149: CURSOR get_internal_loc(p_organization_id NUMBER)
150: IS
151: SELECT location_id
152: FROM hr_organization_units
153: WHERE organization_id = p_organization_id;
154: CURSOR detail_tax_charges_gt (p_header_id oe_order_lines.header_id%type, p_adj_id oe_order_lines.line_id%type )
155: IS
156: SELECT *

Line 558: hr_organization_units hou

554: INTO l_poo_party_id ,
555: l_poo_location_id
556: FROM RA_SALESREPS_ALL sales ,
557: PER_ALL_ASSIGNMENTS_F ASGN ,
558: hr_organization_units hou
559: WHERE ASGN.PERSON_ID = sales.PERSON_ID
560: AND sales.salesrep_id = l_salesrep_id
561: AND sales.org_id = l_header_org_id
562: AND NVL(ASGN.PRIMARY_FLAG, 'Y') = 'Y'