eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_ACCOUNTS

Line 957: | ZX_ACCOUNTS |

953: | This routine processes AP normal Tax codes and inserts appropriate |
954: | data into the following zx base tables. |
955: | ZX_RATES_B |
956: | ZX_RATES_TL |
957: | ZX_ACCOUNTS |
958: | |
959: | SCOPE - PUBLIC |
960: | |
961: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1119: INTO zx_accounts

1115: 1
1116: -- 6820043, commenting out description
1117: -- DESCRIPTION -- Bug 4705196
1118: )
1119: INTO zx_accounts
1120: (
1121: TAX_ACCOUNT_ID ,
1122: TAX_ACCOUNT_ENTITY_ID ,
1123: TAX_ACCOUNT_ENTITY_CODE ,

Line 1167: ZX_ACCOUNTS_S.nextval ,

1163: OBJECT_VERSION_NUMBER
1164: )
1165: VALUES
1166: (
1167: ZX_ACCOUNTS_S.nextval ,
1168: zx_rates_b_s.nextval ,--TAX_RATE_ID
1169: 'RATES' ,
1170: LEDGER_ID ,
1171: ORG_ID ,

Line 1540: INTO zx_accounts

1536: 1
1537: -- 6820043, commenting out description
1538: -- DESCRIPTION -- Bug 4705196
1539: )
1540: INTO zx_accounts
1541: (
1542: TAX_ACCOUNT_ID ,
1543: TAX_ACCOUNT_ENTITY_ID ,
1544: TAX_ACCOUNT_ENTITY_CODE ,

Line 1588: ZX_ACCOUNTS_S.nextval ,

1584: OBJECT_VERSION_NUMBER
1585: )
1586: VALUES
1587: (
1588: ZX_ACCOUNTS_S.nextval ,
1589: zx_rates_b_s.nextval ,--TAX_RATE_ID
1590: 'RATES' ,
1591: LEDGER_ID ,
1592: ORG_ID ,

Line 1971: INTO zx_accounts

1967: TAX_RATE_ID
1968: -- 6820043, commenting out description
1969: -- DESCRIPTION -- Bug 4705196
1970: )
1971: INTO zx_accounts
1972: (
1973: TAX_ACCOUNT_ID ,
1974: TAX_ACCOUNT_ENTITY_ID ,
1975: TAX_ACCOUNT_ENTITY_CODE ,

Line 2019: ZX_ACCOUNTS_S.nextval ,

2015: OBJECT_VERSION_NUMBER
2016: )
2017: VALUES
2018: (
2019: ZX_ACCOUNTS_S.nextval ,
2020: TAX_RATE_ID ,
2021: 'RATES' ,
2022: LEDGER_ID ,
2023: ORG_ID ,

Line 2396: INTO zx_accounts

2392: TAX_RATE_ID
2393: -- 6820043, commenting out description
2394: -- DESCRIPTION -- Bug 4705196
2395: )
2396: INTO zx_accounts
2397: (
2398: TAX_ACCOUNT_ID ,
2399: TAX_ACCOUNT_ENTITY_ID ,
2400: TAX_ACCOUNT_ENTITY_CODE ,

Line 2444: ZX_ACCOUNTS_S.nextval ,

2440: OBJECT_VERSION_NUMBER
2441: )
2442: VALUES
2443: (
2444: ZX_ACCOUNTS_S.nextval ,
2445: TAX_RATE_ID ,
2446: 'RATES' ,
2447: LEDGER_ID ,
2448: ORG_ID ,

Line 2763: | ZX_ACCOUNTS |

2759: | This routine processes assigned OFFSET Tax codes and inserts |
2760: | appropriate data into the following zx base tables. |
2761: | ZX_RATES_B |
2762: | ZX_RATES_TL |
2763: | ZX_ACCOUNTS |
2764: | |
2765: | SCOPE - PUBLIC |
2766: | |
2767: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2923: INTO zx_accounts

2919: 1
2920: -- 6820043, commenting out description
2921: -- DESCRIPTION -- Bug 4705196
2922: )
2923: INTO zx_accounts
2924: (
2925: TAX_ACCOUNT_ID ,
2926: TAX_ACCOUNT_ENTITY_ID ,
2927: TAX_ACCOUNT_ENTITY_CODE ,

Line 2971: ZX_ACCOUNTS_S.NEXTVAL,

2967: OBJECT_VERSION_NUMBER
2968: )
2969: VALUES
2970: (
2971: ZX_ACCOUNTS_S.NEXTVAL,
2972: zx_rates_b_s.nextval ,--TAX_RATE_ID
2973: 'RATES' ,
2974: LEDGER_ID ,
2975: ORG_ID ,

Line 3234: INTO zx_accounts

3230: 1
3231: -- 6820043, commenting out description
3232: -- DESCRIPTION -- Bug 4705196
3233: )
3234: INTO zx_accounts
3235: (
3236: TAX_ACCOUNT_ID ,
3237: TAX_ACCOUNT_ENTITY_ID ,
3238: TAX_ACCOUNT_ENTITY_CODE ,

Line 3282: ZX_ACCOUNTS_S.NEXTVAL ,

3278: OBJECT_VERSION_NUMBER
3279: )
3280: VALUES
3281: (
3282: ZX_ACCOUNTS_S.NEXTVAL ,
3283: zx_rates_b_s.nextval ,--TAX_RATE_ID
3284: 'RATES' ,
3285: LEDGER_ID ,
3286: ORG_ID ,

Line 3554: INTO zx_accounts

3550: TAX_RATE_ID
3551: -- 6820043, commenting out description
3552: -- DESCRIPTION -- Bug 4705196
3553: )
3554: INTO zx_accounts
3555: (
3556: TAX_ACCOUNT_ID ,
3557: TAX_ACCOUNT_ENTITY_ID ,
3558: TAX_ACCOUNT_ENTITY_CODE ,

Line 3602: ZX_ACCOUNTS_S.NEXTVAL ,

3598: OBJECT_VERSION_NUMBER
3599: )
3600: VALUES
3601: (
3602: ZX_ACCOUNTS_S.NEXTVAL ,
3603: TAX_RATE_ID ,
3604: 'RATES' ,
3605: LEDGER_ID ,
3606: ORG_ID ,

Line 3865: INTO zx_accounts

3861: TAX_RATE_ID
3862: -- 6820043, commenting out description
3863: -- DESCRIPTION -- Bug 4705196
3864: )
3865: INTO zx_accounts
3866: (
3867: TAX_ACCOUNT_ID ,
3868: TAX_ACCOUNT_ENTITY_ID ,
3869: TAX_ACCOUNT_ENTITY_CODE ,

Line 3913: ZX_ACCOUNTS_S.NEXTVAL ,

3909: OBJECT_VERSION_NUMBER
3910: )
3911: VALUES
3912: (
3913: ZX_ACCOUNTS_S.NEXTVAL ,
3914: TAX_RATE_ID ,
3915: 'RATES' ,
3916: LEDGER_ID ,
3917: ORG_ID ,

Line 4114: | ZX_ACCOUNTS |

4110: | This routine processes unassigned OFFSET Tax codes and inserts |
4111: | appropriate data into the following zx base tables. |
4112: | ZX_RATES_B |
4113: | ZX_RATES_TL |
4114: | ZX_ACCOUNTS |
4115: | |
4116: | SCOPE - PUBLIC |
4117: | |
4118: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 4273: INTO zx_accounts

4269: 1
4270: -- 6820043, commenting out description
4271: -- DESCRIPTION -- Bug 4705196
4272: )
4273: INTO zx_accounts
4274: (
4275: TAX_ACCOUNT_ID ,
4276: TAX_ACCOUNT_ENTITY_ID ,
4277: TAX_ACCOUNT_ENTITY_CODE ,

Line 4321: ZX_ACCOUNTS_S.NEXTVAL ,

4317: OBJECT_VERSION_NUMBER
4318: )
4319: VALUES
4320: (
4321: ZX_ACCOUNTS_S.NEXTVAL ,
4322: zx_rates_b_s.nextval ,--TAX_RATE_ID
4323: 'RATES' ,
4324: LEDGER_ID ,
4325: ORG_ID ,

Line 4582: INTO zx_accounts

4578: 1
4579: -- 6820043, commenting out description
4580: -- DESCRIPTION -- Bug 4705196
4581: )
4582: INTO zx_accounts
4583: (
4584: TAX_ACCOUNT_ID ,
4585: TAX_ACCOUNT_ENTITY_ID ,
4586: TAX_ACCOUNT_ENTITY_CODE ,

Line 4630: ZX_ACCOUNTS_S.NEXTVAL ,

4626: OBJECT_VERSION_NUMBER
4627: )
4628: VALUES
4629: (
4630: ZX_ACCOUNTS_S.NEXTVAL ,
4631: zx_rates_b_s.nextval ,--TAX_RATE_ID
4632: 'RATES' ,
4633: LEDGER_ID ,
4634: ORG_ID ,

Line 4898: INTO zx_accounts

4894: TAX_RATE_ID
4895: -- 6820043, commenting out description
4896: -- DESCRIPTION -- Bug 4705196
4897: )
4898: INTO zx_accounts
4899: (
4900: TAX_ACCOUNT_ID ,
4901: TAX_ACCOUNT_ENTITY_ID ,
4902: TAX_ACCOUNT_ENTITY_CODE ,

Line 4946: ZX_ACCOUNTS_S.NEXTVAL ,

4942: OBJECT_VERSION_NUMBER
4943: )
4944: VALUES
4945: (
4946: ZX_ACCOUNTS_S.NEXTVAL ,
4947: TAX_RATE_ID ,
4948: 'RATES' ,
4949: LEDGER_ID ,
4950: ORG_ID ,

Line 5209: INTO zx_accounts

5205: TAX_RATE_ID
5206: -- 6820043, commenting out description
5207: -- DESCRIPTION -- Bug 4705196
5208: )
5209: INTO zx_accounts
5210: (
5211: TAX_ACCOUNT_ID ,
5212: TAX_ACCOUNT_ENTITY_ID ,
5213: TAX_ACCOUNT_ENTITY_CODE ,

Line 5257: ZX_ACCOUNTS_S.NEXTVAL ,

5253: OBJECT_VERSION_NUMBER
5254: )
5255: VALUES
5256: (
5257: ZX_ACCOUNTS_S.NEXTVAL ,
5258: TAX_RATE_ID ,
5259: 'RATES' ,
5260: LEDGER_ID ,
5261: ORG_ID ,

Line 5454: | ZX_ACCOUNTS |

5450: | This routine processes distinct recovery rates,inserts appropriate |
5451: | data into the following zx base tables. |
5452: | ZX_RATES_B |
5453: | ZX_RATES_TL |
5454: | ZX_ACCOUNTS |
5455: | |
5456: | SCOPE - PUBLIC |
5457: | |
5458: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 5690: -- No need to insert into ZX_ACCOUNTS for Recovery rates.

5686: END;
5687: end loop;
5688: end;
5689:
5690: -- No need to insert into ZX_ACCOUNTS for Recovery rates.
5691: BEGIN
5692: INSERT INTO ZX_RATES_TL
5693: (
5694: TAX_RATE_ID,

Line 5759: | ZX_ACCOUNTS |

5755: | This routine processes distinct recovery rates,inserts appropriate |
5756: | data into the following zx base tables. |
5757: | ZX_RATES_B |
5758: | ZX_RATES_TL |
5759: | ZX_ACCOUNTS |
5760: | |
5761: | SCOPE - PUBLIC |
5762: | |
5763: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 10056: ZX_ACCOUNTS accounts,

10052: non_rec_account_ccid,
10053: ledger_id,
10054: accounts.internal_organization_id
10055: FROM
10056: ZX_ACCOUNTS accounts,
10057: ZX_RATES_B rates,
10058: ZX_TAXES_B taxes
10059: WHERE taxes.tax = rates.tax
10060: and taxes.tax_regime_code = rates.tax_regime_code

Line 10074: TYPE ac_id_tab IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE

10070: ------------------------pl/sql table declarations----------------------------
10071: TYPE tax_id_tab IS TABLE OF ZX_TAXES_B.TAX_ID%TYPE
10072: INDEX BY BINARY_INTEGER;
10073:
10074: TYPE ac_id_tab IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE
10075: INDEX BY BINARY_INTEGER;
10076:
10077: TYPE ledger_id_tab IS TABLE OF ZX_ACCOUNTS.LEDGER_ID%TYPE
10078: INDEX BY BINARY_INTEGER;

Line 10077: TYPE ledger_id_tab IS TABLE OF ZX_ACCOUNTS.LEDGER_ID%TYPE

10073:
10074: TYPE ac_id_tab IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE
10075: INDEX BY BINARY_INTEGER;
10076:
10077: TYPE ledger_id_tab IS TABLE OF ZX_ACCOUNTS.LEDGER_ID%TYPE
10078: INDEX BY BINARY_INTEGER;
10079:
10080: TYPE org_id_tab IS TABLE OF ZX_ACCOUNTS.INTERNAL_ORGANIZATION_ID%TYPE
10081: INDEX BY BINARY_INTEGER;

Line 10080: TYPE org_id_tab IS TABLE OF ZX_ACCOUNTS.INTERNAL_ORGANIZATION_ID%TYPE

10076:
10077: TYPE ledger_id_tab IS TABLE OF ZX_ACCOUNTS.LEDGER_ID%TYPE
10078: INDEX BY BINARY_INTEGER;
10079:
10080: TYPE org_id_tab IS TABLE OF ZX_ACCOUNTS.INTERNAL_ORGANIZATION_ID%TYPE
10081: INDEX BY BINARY_INTEGER;
10082:
10083: -----The tables given below used to collect all account info. records-------
10084:

Line 10109: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;

10105: v_count number;
10106: v_insert_flag boolean;
10107:
10108: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10109: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10110: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10111: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10112:
10113:

Line 10111: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;

10107:
10108: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10109: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10110: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10111: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10112:
10113:
10114: BEGIN
10115: arp_util_tax.debug('Create Tax Accounts(+)');

Line 10215: INSERT INTO ZX_ACCOUNTS

10211: END IF;
10212:
10213: FORALL j IN 1..nvl(pg_max_tax_id_tab.last,0)
10214:
10215: INSERT INTO ZX_ACCOUNTS
10216: (
10217: TAX_ACCOUNT_ENTITY_CODE,
10218: TAX_ACCOUNT_CCID,
10219: INTERIM_TAX_CCID,

Line 10300: zx_accounts_s.nextval,

10296: NULL,
10297: NULL,
10298: NULL,
10299: fnd_global.conc_login_id,
10300: zx_accounts_s.nextval,
10301: pg_max_tax_id_tab(j),
10302: pg_max_ledger_id_tab(j),
10303: pg_max_org_id_tab(j),
10304: 1

Line 10307: ( SELECT NULL FROM ZX_ACCOUNTS accounts

10303: pg_max_org_id_tab(j),
10304: 1
10305:
10306: FROM DUAL WHERE NOT EXISTS
10307: ( SELECT NULL FROM ZX_ACCOUNTS accounts
10308: WHERE accounts.TAX_ACCOUNT_ENTITY_CODE = 'TAXES' and
10309: accounts.TAX_ACCOUNT_ENTITY_ID = pg_max_tax_id_tab(j)
10310: )
10311: );

Line 10574: INTO zx_accounts

10570: 1
10571: -- 6820043, commenting out description
10572: -- DESCRIPTION -- Bug 4705196
10573: )
10574: INTO zx_accounts
10575: (
10576: TAX_ACCOUNT_ID ,
10577: TAX_ACCOUNT_ENTITY_ID ,
10578: TAX_ACCOUNT_ENTITY_CODE ,

Line 10622: ZX_ACCOUNTS_S.nextval ,

10618: OBJECT_VERSION_NUMBER
10619: )
10620: VALUES
10621: (
10622: ZX_ACCOUNTS_S.nextval ,
10623: zx_rates_b_s.nextval ,--TAX_RATE_ID
10624: 'RATES' ,
10625: LEDGER_ID ,
10626: ORG_ID ,

Line 10997: INTO zx_accounts

10993: 1
10994: -- 6820043, commenting out description
10995: -- DESCRIPTION -- Bug 4705196
10996: )
10997: INTO zx_accounts
10998: (
10999: TAX_ACCOUNT_ID ,
11000: TAX_ACCOUNT_ENTITY_ID ,
11001: TAX_ACCOUNT_ENTITY_CODE ,

Line 11045: ZX_ACCOUNTS_S.nextval ,

11041: OBJECT_VERSION_NUMBER
11042: )
11043: VALUES
11044: (
11045: ZX_ACCOUNTS_S.nextval ,
11046: zx_rates_b_s.nextval ,--TAX_RATE_ID
11047: 'RATES' ,
11048: LEDGER_ID ,
11049: ORG_ID ,

Line 11434: INTO zx_accounts

11430: TAX_RATE_ID
11431: -- 6820043, commenting out description
11432: -- DESCRIPTION -- Bug 4705196
11433: )
11434: INTO zx_accounts
11435: (
11436: TAX_ACCOUNT_ID ,
11437: TAX_ACCOUNT_ENTITY_ID ,
11438: TAX_ACCOUNT_ENTITY_CODE ,

Line 11482: ZX_ACCOUNTS_S.nextval ,

11478: OBJECT_VERSION_NUMBER
11479: )
11480: VALUES
11481: (
11482: ZX_ACCOUNTS_S.nextval ,
11483: TAX_RATE_ID ,
11484: 'RATES' ,
11485: LEDGER_ID ,
11486: ORG_ID ,

Line 11859: INTO zx_accounts

11855: TAX_RATE_ID
11856: -- 6820043, commenting out description
11857: -- DESCRIPTION -- Bug 4705196
11858: )
11859: INTO zx_accounts
11860: (
11861: TAX_ACCOUNT_ID ,
11862: TAX_ACCOUNT_ENTITY_ID ,
11863: TAX_ACCOUNT_ENTITY_CODE ,

Line 11907: ZX_ACCOUNTS_S.nextval ,

11903: OBJECT_VERSION_NUMBER
11904: )
11905: VALUES
11906: (
11907: ZX_ACCOUNTS_S.nextval ,
11908: TAX_RATE_ID ,
11909: 'RATES' ,
11910: LEDGER_ID ,
11911: ORG_ID ,

Line 12301: INTO zx_accounts

12297: 1
12298: -- 6820043, commenting out description
12299: -- DESCRIPTION -- Bug 4705196
12300: )
12301: INTO zx_accounts
12302: (
12303: TAX_ACCOUNT_ID ,
12304: TAX_ACCOUNT_ENTITY_ID ,
12305: TAX_ACCOUNT_ENTITY_CODE ,

Line 12349: ZX_ACCOUNTS_S.nextval ,

12345: OBJECT_VERSION_NUMBER
12346: )
12347: VALUES
12348: (
12349: ZX_ACCOUNTS_S.nextval ,
12350: zx_rates_b_s.nextval ,--TAX_RATE_ID
12351: 'RATES' ,
12352: LEDGER_ID ,
12353: ORG_ID ,

Line 12725: INTO zx_accounts

12721: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
12722: 1
12723: -- , DESCRIPTION -- Bug 4705196
12724: )
12725: INTO zx_accounts
12726: (
12727: TAX_ACCOUNT_ID ,
12728: TAX_ACCOUNT_ENTITY_ID ,
12729: TAX_ACCOUNT_ENTITY_CODE ,

Line 12773: ZX_ACCOUNTS_S.nextval ,

12769: OBJECT_VERSION_NUMBER
12770: )
12771: VALUES
12772: (
12773: ZX_ACCOUNTS_S.nextval ,
12774: zx_rates_b_s.nextval ,--TAX_RATE_ID
12775: 'RATES' ,
12776: LEDGER_ID ,
12777: ORG_ID ,

Line 13164: INTO zx_accounts

13160: TAX_RATE_ID
13161: -- 6820043, commenting out description
13162: -- DESCRIPTION -- Bug 4705196
13163: )
13164: INTO zx_accounts
13165: (
13166: TAX_ACCOUNT_ID ,
13167: TAX_ACCOUNT_ENTITY_ID ,
13168: TAX_ACCOUNT_ENTITY_CODE ,

Line 13212: ZX_ACCOUNTS_S.nextval ,

13208: OBJECT_VERSION_NUMBER
13209: )
13210: VALUES
13211: (
13212: ZX_ACCOUNTS_S.nextval ,
13213: TAX_RATE_ID ,
13214: 'RATES' ,
13215: LEDGER_ID ,
13216: ORG_ID ,

Line 13589: INTO zx_accounts

13585: TAX_RATE_ID
13586: -- 6820043, commenting out description
13587: -- DESCRIPTION -- Bug 4705196
13588: )
13589: INTO zx_accounts
13590: (
13591: TAX_ACCOUNT_ID ,
13592: TAX_ACCOUNT_ENTITY_ID ,
13593: TAX_ACCOUNT_ENTITY_CODE ,

Line 13637: ZX_ACCOUNTS_S.nextval ,

13633: OBJECT_VERSION_NUMBER
13634: )
13635: VALUES
13636: (
13637: ZX_ACCOUNTS_S.nextval ,
13638: TAX_RATE_ID ,
13639: 'RATES' ,
13640: LEDGER_ID ,
13641: ORG_ID ,