DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on FND_TERRITORIES_VL

Line 6092: FROM fnd_territories_vl

6088: fnd_file.put_line(fnd_file.log, ' Validating Country name');
6089: BEGIN
6090: SELECT territory_code
6091: INTO x_country_code
6092: FROM fnd_territories_vl
6093: WHERE territory_short_name = p_tax_profile_rec.country_name;
6094:
6095: -- Update the Interface table with the country code obtained in the prev SQL since the country code would be saved.
6096: EXCEPTION

Line 9012: fnd_territories_vl fvl

9008: , hzl.city , hzl.postal_code*/
9009: INTO l_party_site_id
9010: FROM hz_party_sites hps,
9011: hz_locations hzl,
9012: fnd_territories_vl fvl
9013: WHERE hps.party_id = l_party_id
9014: AND hzl.location_id = hps.location_id
9015: AND hps.status = 'A'
9016: AND fvl.territory_code = hzl.country