APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_STATUS_B_TMP

Line 2632: INTO ZX_STATUS_B_TMP

2628:
2629: END IF;
2630: -- ****** Inserting status for taxes (created for qualifier and location tax code) ******
2631: INSERT ALL
2632: INTO ZX_STATUS_B_TMP
2633: (
2634: TAX_STATUS_ID,
2635: TAX_STATUS_CODE,
2636: CONTENT_OWNER_ID,

Line 3950: INTO ZX_STATUS_B_TMP

3946:
3947: -- Populate Status : Taxware and Vertex
3948:
3949: INSERT ALL
3950: INTO ZX_STATUS_B_TMP
3951: (
3952: TAX_STATUS_ID,
3953: TAX_STATUS_CODE,
3954: CONTENT_OWNER_ID,

Line 6596: INSERT INTO ZX_STATUS_B_TMP

6592:
6593: -- Status creation excluding LTE related status code
6594: IF L_MULTI_ORG_FLAG = 'Y'
6595: THEN
6596: INSERT INTO ZX_STATUS_B_TMP
6597: (
6598: TAX_STATUS_ID,
6599: TAX_STATUS_CODE,
6600: CONTENT_OWNER_ID,

Line 6722: INSERT INTO ZX_STATUS_B_TMP

6718: END
6719: ) STATUS;
6720: ELSE
6721:
6722: INSERT INTO ZX_STATUS_B_TMP
6723: (
6724: TAX_STATUS_ID,
6725: TAX_STATUS_CODE,
6726: CONTENT_OWNER_ID,

Line 6857: INSERT INTO ZX_STATUS_B_TMP

6853: --arp_util_tax.debug('1:');
6854:
6855: /*
6856: -- LTE handling
6857: INSERT INTO ZX_STATUS_B_TMP
6858: (
6859: TAX_STATUS_ID,
6860: TAX_STATUS_CODE,
6861: CONTENT_OWNER_ID,

Line 6997: INSERT INTO ZX_STATUS_B_TMP

6993: -- Unused JATW_GOVERNMENT_TAX_TYPE global flexfield atttribute handling
6994: IF L_JATW_USED = 'Y' THEN
6995: IF L_MULTI_ORG_FLAG = 'Y' THEN
6996:
6997: INSERT INTO ZX_STATUS_B_TMP
6998: (
6999: TAX_STATUS_ID,
7000: TAX_STATUS_CODE,
7001: CONTENT_OWNER_ID,

Line 7147: INSERT INTO ZX_STATUS_B_TMP

7143: --YK:8/31/2004: selects unused TW GDF.
7144: --Does cartesian join to create all combination for regime, tax, content_onwer_id
7145: --status_code fetched in STATUSES.
7146: ELSE
7147: INSERT INTO ZX_STATUS_B_TMP
7148: (
7149: TAX_STATUS_ID,
7150: TAX_STATUS_CODE,
7151: CONTENT_OWNER_ID,

Line 8840: update zx_status_b_tmp

8836: ||l_org_id(i)||sqlerrm);
8837: END;
8838:
8839: BEGIN
8840: update zx_status_b_tmp
8841: set allow_rate_override_flag = 'N',
8842: object_version_number = object_version_number + 1
8843: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile
8844: where party_id= to_number(l_org_id(i))

Line 10347: UPDATE zx_status_b_tmp

10343: allow_exceptions_flag = l_allow_exceptions_flag
10344: WHERE content_owner_id = cursor_rec.party_tax_profile_id
10345: AND record_type_code = 'MIGRATED';
10346:
10347: UPDATE zx_status_b_tmp
10348: SET allow_exemptions_flag = l_allow_exemptions_flag,
10349: allow_exceptions_flag = l_allow_exceptions_flag
10350: WHERE content_owner_id = cursor_rec.party_tax_profile_id
10351: AND record_type_code = 'MIGRATED';