APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on FND_TERRITORIES_VL

Line 4967: fnd_territories_vl te

4963: hz_loc.province, hz_loc.country, te.iso_territory_code, te.territory_short_name, hz_loc.postal_code,
4964: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id),
4965: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')
4966: FROM hz_locations hz_loc,
4967: fnd_territories_vl te
4968: WHERE hz_loc.country = te.territory_code
4969: AND location_id = p_location_id;
4970: /*
4971: SELECT address

Line 5105: fnd_territories_vl te

5101: hz_loc.province, hz_loc.country, te.iso_territory_code, te.territory_short_name, hz_loc.postal_code,
5102: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id),
5103: IBY_FD_EXTRACT_GEN_PVT.format_hz_address(hz_loc.location_id, 'POSTAL_ADDR')
5104: FROM hz_locations hz_loc,
5105: fnd_territories_vl te
5106: WHERE hz_loc.country = te.territory_code
5107: AND location_id = p_location_id;
5108:
5109: /* SELECT address

Line 5116: FROM fnd_territories_vl te

5112:
5113:
5114: CURSOR l_country_csr (p_country IN VARCHAR2) IS
5115: SELECT te.iso_territory_code , te.territory_short_name
5116: FROM fnd_territories_vl te
5117: WHERE te.territory_code = p_country;
5118:
5119:
5120: BEGIN

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