APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_STATUS_B_TMP

Line 2544: INTO ZX_STATUS_B_TMP

2540:
2541: END IF;
2542: -- ****** Inserting status for taxes (created for qualifier and location tax code) ******
2543: INSERT ALL
2544: INTO ZX_STATUS_B_TMP
2545: (
2546: TAX_STATUS_ID,
2547: TAX_STATUS_CODE,
2548: CONTENT_OWNER_ID,

Line 3828: INTO ZX_STATUS_B_TMP

3824: -- Populate Status : Taxware and Vertex
3825: IF L_MULTI_ORG_FLAG = 'Y'
3826: THEN
3827: INSERT ALL
3828: INTO ZX_STATUS_B_TMP
3829: (
3830: TAX_STATUS_ID,
3831: TAX_STATUS_CODE,
3832: CONTENT_OWNER_ID,

Line 3965: INTO ZX_STATUS_B_TMP

3961: AND zsb.tax_status_code = 'STANDARD');
3962: ELSE
3963:
3964: INSERT ALL
3965: INTO ZX_STATUS_B_TMP
3966: (
3967: TAX_STATUS_ID,
3968: TAX_STATUS_CODE,
3969: CONTENT_OWNER_ID,

Line 6584: INSERT INTO ZX_STATUS_B_TMP

6580:
6581: -- Status creation excluding LTE related status code
6582: IF L_MULTI_ORG_FLAG = 'Y'
6583: THEN
6584: INSERT INTO ZX_STATUS_B_TMP
6585: (
6586: TAX_STATUS_ID,
6587: TAX_STATUS_CODE,
6588: CONTENT_OWNER_ID,

Line 6710: INSERT INTO ZX_STATUS_B_TMP

6706: END
6707: ) STATUS;
6708: ELSE
6709:
6710: INSERT INTO ZX_STATUS_B_TMP
6711: (
6712: TAX_STATUS_ID,
6713: TAX_STATUS_CODE,
6714: CONTENT_OWNER_ID,

Line 6845: INSERT INTO ZX_STATUS_B_TMP

6841: --arp_util_tax.debug('1:');
6842:
6843: /*
6844: -- LTE handling
6845: INSERT INTO ZX_STATUS_B_TMP
6846: (
6847: TAX_STATUS_ID,
6848: TAX_STATUS_CODE,
6849: CONTENT_OWNER_ID,

Line 6985: INSERT INTO ZX_STATUS_B_TMP

6981: -- Unused JATW_GOVERNMENT_TAX_TYPE global flexfield atttribute handling
6982: IF L_JATW_USED = 'Y' THEN
6983: IF L_MULTI_ORG_FLAG = 'Y' THEN
6984:
6985: INSERT INTO ZX_STATUS_B_TMP
6986: (
6987: TAX_STATUS_ID,
6988: TAX_STATUS_CODE,
6989: CONTENT_OWNER_ID,

Line 7135: INSERT INTO ZX_STATUS_B_TMP

7131: --YK:8/31/2004: selects unused TW GDF.
7132: --Does cartesian join to create all combination for regime, tax, content_onwer_id
7133: --status_code fetched in STATUSES.
7134: ELSE
7135: INSERT INTO ZX_STATUS_B_TMP
7136: (
7137: TAX_STATUS_ID,
7138: TAX_STATUS_CODE,
7139: CONTENT_OWNER_ID,

Line 8828: update zx_status_b_tmp

8824: ||l_org_id(i)||sqlerrm);
8825: END;
8826:
8827: BEGIN
8828: update zx_status_b_tmp
8829: set allow_rate_override_flag = 'N',
8830: object_version_number = object_version_number + 1
8831: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile
8832: where party_id= to_number(l_org_id(i))

Line 10338: UPDATE zx_status_b_tmp

10334: allow_exceptions_flag = l_allow_exceptions_flag
10335: WHERE content_owner_id = cursor_rec.party_tax_profile_id
10336: AND record_type_code = 'MIGRATED';
10337:
10338: UPDATE zx_status_b_tmp
10339: SET allow_exemptions_flag = l_allow_exemptions_flag,
10340: allow_exceptions_flag = l_allow_exceptions_flag
10341: WHERE content_owner_id = cursor_rec.party_tax_profile_id
10342: AND record_type_code = 'MIGRATED';