DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on FND_TERRITORIES

Line 1268: FROM fnd_territories

1264: WHERE (( country_code IS NOT NULL
1265: AND NOT EXISTS
1266: (
1267: SELECT 1
1268: FROM fnd_territories
1269: WHERE territory_code = ptp_int.country_code
1270: )
1271: )
1272: OR

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