DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on FND_TERRITORIES_VL

Line 1278: FROM fnd_territories_vl

1274: AND country_name IS NOT NULL
1275: AND NOT EXISTS
1276: (
1277: SELECT 1
1278: FROM fnd_territories_vl
1279: WHERE territory_short_name = ptp_int.country_name
1280: )
1281: )
1282: )

Line 1295: FROM fnd_territories_vl

1291: -- value to id conversion for registration_type_code
1292: UPDATE zx_party_tax_profile_int ptp_int
1293: SET country_code = (
1294: SELECT territory_code
1295: FROM fnd_territories_vl
1296: WHERE territory_short_name = ptp_int.country_name
1297: )
1298: WHERE record_status = G_RS_IN_PROCESS
1299: AND request_id = G_REQUEST_ID