APPS.PAY_MX_ANNUAL_WRI dependencies on HR_LOCATIONS

Line 623: FROM hr_locations hl,

619: hr_general.decode_lookup('PER_MX_STATE_CODES', hl.region_1),
620: ft.territory_short_name,
621: hl.telephone_number_1,
622: hl.telephone_number_2
623: FROM hr_locations hl,
624: hr_organization_units hou,
625: fnd_territories_vl ft
626: WHERE hou.location_id = hl.location_id
627: AND ft.territory_code = hl.country

Line 631: lv_street hr_locations.address_line_1%type;

627: AND ft.territory_code = hl.country
628: AND hou.organization_id = g_gre_id;
629:
630:
631: lv_street hr_locations.address_line_1%type;
632: lv_neighborhood hr_locations.address_line_2%type;
633: lv_municipality hr_locations.region_2%type;
634: lv_postal_code hr_locations.postal_code%type;
635: lv_city hr_locations.town_or_city%type;

Line 632: lv_neighborhood hr_locations.address_line_2%type;

628: AND hou.organization_id = g_gre_id;
629:
630:
631: lv_street hr_locations.address_line_1%type;
632: lv_neighborhood hr_locations.address_line_2%type;
633: lv_municipality hr_locations.region_2%type;
634: lv_postal_code hr_locations.postal_code%type;
635: lv_city hr_locations.town_or_city%type;
636: lv_state hr_locations.region_1%type;

Line 633: lv_municipality hr_locations.region_2%type;

629:
630:
631: lv_street hr_locations.address_line_1%type;
632: lv_neighborhood hr_locations.address_line_2%type;
633: lv_municipality hr_locations.region_2%type;
634: lv_postal_code hr_locations.postal_code%type;
635: lv_city hr_locations.town_or_city%type;
636: lv_state hr_locations.region_1%type;
637: lv_country hr_lookups.meaning%type;

Line 634: lv_postal_code hr_locations.postal_code%type;

630:
631: lv_street hr_locations.address_line_1%type;
632: lv_neighborhood hr_locations.address_line_2%type;
633: lv_municipality hr_locations.region_2%type;
634: lv_postal_code hr_locations.postal_code%type;
635: lv_city hr_locations.town_or_city%type;
636: lv_state hr_locations.region_1%type;
637: lv_country hr_lookups.meaning%type;
638: lv_telephone hr_locations.telephone_number_1%type;

Line 635: lv_city hr_locations.town_or_city%type;

631: lv_street hr_locations.address_line_1%type;
632: lv_neighborhood hr_locations.address_line_2%type;
633: lv_municipality hr_locations.region_2%type;
634: lv_postal_code hr_locations.postal_code%type;
635: lv_city hr_locations.town_or_city%type;
636: lv_state hr_locations.region_1%type;
637: lv_country hr_lookups.meaning%type;
638: lv_telephone hr_locations.telephone_number_1%type;
639: lv_fax hr_locations.telephone_number_2%type;

Line 636: lv_state hr_locations.region_1%type;

632: lv_neighborhood hr_locations.address_line_2%type;
633: lv_municipality hr_locations.region_2%type;
634: lv_postal_code hr_locations.postal_code%type;
635: lv_city hr_locations.town_or_city%type;
636: lv_state hr_locations.region_1%type;
637: lv_country hr_lookups.meaning%type;
638: lv_telephone hr_locations.telephone_number_1%type;
639: lv_fax hr_locations.telephone_number_2%type;
640: l_proc_name varchar2(100);

Line 638: lv_telephone hr_locations.telephone_number_1%type;

634: lv_postal_code hr_locations.postal_code%type;
635: lv_city hr_locations.town_or_city%type;
636: lv_state hr_locations.region_1%type;
637: lv_country hr_lookups.meaning%type;
638: lv_telephone hr_locations.telephone_number_1%type;
639: lv_fax hr_locations.telephone_number_2%type;
640: l_proc_name varchar2(100);
641: lv_buf varchar2(8000);
642: l_xml BLOB;

Line 639: lv_fax hr_locations.telephone_number_2%type;

635: lv_city hr_locations.town_or_city%type;
636: lv_state hr_locations.region_1%type;
637: lv_country hr_lookups.meaning%type;
638: lv_telephone hr_locations.telephone_number_1%type;
639: lv_fax hr_locations.telephone_number_2%type;
640: l_proc_name varchar2(100);
641: lv_buf varchar2(8000);
642: l_xml BLOB;
643: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;