APPS.PAY_MX_RULES dependencies on HR_ORGANIZATION_UNITS

Line 542: FROM hr_organization_units hou

538: p_document_type varchar2) as
539:
540: CURSOR c_get_bus_grp_id(p_tax_unit_id number) IS
541: SELECT hou.business_group_id
542: FROM hr_organization_units hou
543: WHERE hou.organization_id = p_tax_unit_id;
544:
545: CURSOR get_tax_unit_id(p_asg_action_id number) IS
546: SELECT tax_unit_id

Line 553: FROM hr_organization_units hou

549:
550: CURSOR c_get_employer_information(p_org_id number) IS
551: SELECT hoi.org_information1
552: ,hou.location_id
553: FROM hr_organization_units hou
554: ,hr_organization_information hoi
555: WHERE hou.organization_id = p_org_id
556: AND hoi.organization_id = hou.organization_id
557: AND hoi.org_information_context = 'MX_TAX_REGISTRATION';

Line 617: lv_org_name hr_organization_units.name%TYPE;

613:
614:
615: ln_tax_unit_id number;
616: ln_bus_grp_id number;
617: lv_org_name hr_organization_units.name%TYPE;
618: ln_location_id hr_organization_units.location_id%TYPE;
619: lv_address_line1 hr_locations.address_line_1%TYPE;
620: lv_address_line2 hr_locations.address_line_2%TYPE;
621: lv_address_line3 hr_locations.address_line_3%TYPE;

Line 618: ln_location_id hr_organization_units.location_id%TYPE;

614:
615: ln_tax_unit_id number;
616: ln_bus_grp_id number;
617: lv_org_name hr_organization_units.name%TYPE;
618: ln_location_id hr_organization_units.location_id%TYPE;
619: lv_address_line1 hr_locations.address_line_1%TYPE;
620: lv_address_line2 hr_locations.address_line_2%TYPE;
621: lv_address_line3 hr_locations.address_line_3%TYPE;
622: lv_town_or_city hr_locations.town_or_city%TYPE;