APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on HR_LOCATIONS

Line 1590: ,hr_locations hl

1586: ,ft.territory_short_name country
1587: ,hl.postal_code
1588: ,hl.telephone_number_1
1589: FROM hr_all_organization_units hou
1590: ,hr_locations hl
1591: ,fnd_territories_tl ft
1592: WHERE hou.organization_id = p_employer_id
1593: AND hou.location_id = hl.location_id
1594: AND hl.country = ft.territory_code

Line 1606: l_address_line_1 hr_locations.address_line_1%TYPE;

1602: WHERE hoi.organization_id = p_employer_id
1603: AND hoi.org_information_context like 'PER_EMPLOYER_INFO_CN' ;
1604: --
1605: l_dummy VARCHAR2(10);
1606: l_address_line_1 hr_locations.address_line_1%TYPE;
1607: l_address_line_2 hr_locations.address_line_2%TYPE;
1608: l_province hr_lookups.meaning%TYPE;
1609: l_country fnd_territories_tl.territory_short_name%TYPE;
1610: l_postal_code hr_locations.postal_code%TYPE;

Line 1607: l_address_line_2 hr_locations.address_line_2%TYPE;

1603: AND hoi.org_information_context like 'PER_EMPLOYER_INFO_CN' ;
1604: --
1605: l_dummy VARCHAR2(10);
1606: l_address_line_1 hr_locations.address_line_1%TYPE;
1607: l_address_line_2 hr_locations.address_line_2%TYPE;
1608: l_province hr_lookups.meaning%TYPE;
1609: l_country fnd_territories_tl.territory_short_name%TYPE;
1610: l_postal_code hr_locations.postal_code%TYPE;
1611: l_telephone_no hr_locations.telephone_number_1%TYPE;

Line 1610: l_postal_code hr_locations.postal_code%TYPE;

1606: l_address_line_1 hr_locations.address_line_1%TYPE;
1607: l_address_line_2 hr_locations.address_line_2%TYPE;
1608: l_province hr_lookups.meaning%TYPE;
1609: l_country fnd_territories_tl.territory_short_name%TYPE;
1610: l_postal_code hr_locations.postal_code%TYPE;
1611: l_telephone_no hr_locations.telephone_number_1%TYPE;
1612: l_file_number hr_organization_information.org_information8%TYPE;
1613: l_procedure VARCHAR2(80);
1614: l_ovn NUMBER;

Line 1611: l_telephone_no hr_locations.telephone_number_1%TYPE;

1607: l_address_line_2 hr_locations.address_line_2%TYPE;
1608: l_province hr_lookups.meaning%TYPE;
1609: l_country fnd_territories_tl.territory_short_name%TYPE;
1610: l_postal_code hr_locations.postal_code%TYPE;
1611: l_telephone_no hr_locations.telephone_number_1%TYPE;
1612: l_file_number hr_organization_information.org_information8%TYPE;
1613: l_procedure VARCHAR2(80);
1614: l_ovn NUMBER;
1615: l_action_info_id NUMBER;