APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on HR_LOCATIONS

Line 1462: ,hr_locations hl

1458: ,ft.territory_short_name country
1459: ,hl.postal_code
1460: ,hl.telephone_number_1
1461: FROM hr_all_organization_units hou
1462: ,hr_locations hl
1463: ,fnd_territories_tl ft
1464: WHERE hou.organization_id = p_employer_id
1465: AND hou.location_id = hl.location_id
1466: AND hl.country = ft.territory_code

Line 1478: l_address_line_1 hr_locations.address_line_1%TYPE;

1474: WHERE hoi.organization_id = p_employer_id
1475: AND hoi.org_information_context like 'PER_EMPLOYER_INFO_CN' ;
1476: --
1477: l_dummy VARCHAR2(10);
1478: l_address_line_1 hr_locations.address_line_1%TYPE;
1479: l_address_line_2 hr_locations.address_line_2%TYPE;
1480: l_province hr_lookups.meaning%TYPE;
1481: l_country fnd_territories_tl.territory_short_name%TYPE;
1482: l_postal_code hr_locations.postal_code%TYPE;

Line 1479: l_address_line_2 hr_locations.address_line_2%TYPE;

1475: AND hoi.org_information_context like 'PER_EMPLOYER_INFO_CN' ;
1476: --
1477: l_dummy VARCHAR2(10);
1478: l_address_line_1 hr_locations.address_line_1%TYPE;
1479: l_address_line_2 hr_locations.address_line_2%TYPE;
1480: l_province hr_lookups.meaning%TYPE;
1481: l_country fnd_territories_tl.territory_short_name%TYPE;
1482: l_postal_code hr_locations.postal_code%TYPE;
1483: l_telephone_no hr_locations.telephone_number_1%TYPE;

Line 1482: l_postal_code hr_locations.postal_code%TYPE;

1478: l_address_line_1 hr_locations.address_line_1%TYPE;
1479: l_address_line_2 hr_locations.address_line_2%TYPE;
1480: l_province hr_lookups.meaning%TYPE;
1481: l_country fnd_territories_tl.territory_short_name%TYPE;
1482: l_postal_code hr_locations.postal_code%TYPE;
1483: l_telephone_no hr_locations.telephone_number_1%TYPE;
1484: l_file_number hr_organization_information.org_information8%TYPE;
1485: l_procedure VARCHAR2(80);
1486: l_ovn NUMBER;

Line 1483: l_telephone_no hr_locations.telephone_number_1%TYPE;

1479: l_address_line_2 hr_locations.address_line_2%TYPE;
1480: l_province hr_lookups.meaning%TYPE;
1481: l_country fnd_territories_tl.territory_short_name%TYPE;
1482: l_postal_code hr_locations.postal_code%TYPE;
1483: l_telephone_no hr_locations.telephone_number_1%TYPE;
1484: l_file_number hr_organization_information.org_information8%TYPE;
1485: l_procedure VARCHAR2(80);
1486: l_ovn NUMBER;
1487: l_action_info_id NUMBER;