APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on HR_LOCATIONS_ALL

Line 2121: FROM hr_locations_all hr_loc, xle_firstparty_information_v xle_firstparty

2117: AND status = 'A';
2118:
2119: CURSOR l_hr_loc_contact_csr (p_party_id IN NUMBER) IS
2120: SELECT TELEPHONE_NUMBER_1, TELEPHONE_NUMBER_2
2121: FROM hr_locations_all hr_loc, xle_firstparty_information_v xle_firstparty
2122: WHERE hr_loc.location_id = xle_firstparty.location_id
2123: AND xle_firstparty.party_id = p_party_id;
2124:
2125: BEGIN

Line 2585: FROM hr_locations_all

2581: CURSOR l_hr_loc_csr (p_hr_location_id IN NUMBER) IS
2582: SELECT address_line_1, address_line_2, address_line_3,
2583: town_or_city, region_1, region_2,
2584: postal_code, country
2585: FROM hr_locations_all
2586: WHERE location_id = p_hr_location_id;
2587:
2588: BEGIN
2589:

Line 5272: FROM hr_locations_all hr_loc, fnd_territories_vl te

5268: te.iso_territory_code, te.territory_short_name, hr_loc.postal_code,
5269: IBY_FD_EXTRACT_GEN_PVT.format_hr_address(hr_loc.location_id),
5270: IBY_FD_EXTRACT_GEN_PVT.format_hr_address(hr_loc.location_id, 'POSTAL_ADDR'),
5271: hr_loc.location_code
5272: FROM hr_locations_all hr_loc, fnd_territories_vl te
5273: WHERE hr_loc.country = te.territory_code(+)
5274: AND location_id = p_location_id;
5275: /*
5276: SELECT address