APPS.PAY_MX_RULES dependencies on HR_ORGANIZATION_UNITS

Line 561: FROM hr_organization_units hou

557: p_document_type varchar2) as
558:
559: CURSOR c_get_bus_grp_id(p_tax_unit_id number) IS
560: SELECT hou.business_group_id
561: FROM hr_organization_units hou
562: WHERE hou.organization_id = p_tax_unit_id;
563:
564: CURSOR get_tax_unit_id(p_asg_action_id number) IS
565: SELECT tax_unit_id

Line 572: FROM hr_organization_units hou

568:
569: CURSOR c_get_employer_information(p_org_id number) IS
570: SELECT hoi.org_information1
571: ,hou.location_id
572: FROM hr_organization_units hou
573: ,hr_organization_information hoi
574: WHERE hou.organization_id = p_org_id
575: AND hoi.organization_id = hou.organization_id
576: AND hoi.org_information_context = 'MX_TAX_REGISTRATION';

Line 636: lv_org_name hr_organization_units.name%TYPE;

632:
633:
634: ln_tax_unit_id number;
635: ln_bus_grp_id number;
636: lv_org_name hr_organization_units.name%TYPE;
637: ln_location_id hr_organization_units.location_id%TYPE;
638: lv_address_line1 hr_locations.address_line_1%TYPE;
639: lv_address_line2 hr_locations.address_line_2%TYPE;
640: lv_address_line3 hr_locations.address_line_3%TYPE;

Line 637: ln_location_id hr_organization_units.location_id%TYPE;

633:
634: ln_tax_unit_id number;
635: ln_bus_grp_id number;
636: lv_org_name hr_organization_units.name%TYPE;
637: ln_location_id hr_organization_units.location_id%TYPE;
638: lv_address_line1 hr_locations.address_line_1%TYPE;
639: lv_address_line2 hr_locations.address_line_2%TYPE;
640: lv_address_line3 hr_locations.address_line_3%TYPE;
641: lv_town_or_city hr_locations.town_or_city%TYPE;