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_TCM_COMPOUND_PKG dependencies on ZX_TAX_PRIORITIES_T

Line 163: zx_tax_priorities_t rega,

159: FROM ar_tax_group_codes_all a,
160: ar_tax_group_codes_all b,
161: ar_vat_tax_all_b aa,
162: ar_vat_tax_all_b bb,
163: zx_tax_priorities_t rega,
164: zx_tax_priorities_t regb,
165: zx_party_tax_profile ptp,
166: ar_vat_tax_all_b grp
167: WHERE decode(l_multi_org_flag,'N',l_org_id,a.org_id) = decode(l_multi_org_flag,'N',l_org_id,b.org_id)

Line 164: zx_tax_priorities_t regb,

160: ar_tax_group_codes_all b,
161: ar_vat_tax_all_b aa,
162: ar_vat_tax_all_b bb,
163: zx_tax_priorities_t rega,
164: zx_tax_priorities_t regb,
165: zx_party_tax_profile ptp,
166: ar_vat_tax_all_b grp
167: WHERE decode(l_multi_org_flag,'N',l_org_id,a.org_id) = decode(l_multi_org_flag,'N',l_org_id,b.org_id)
168: AND decode(l_multi_org_flag,'N',l_org_id,a.org_id) = decode(l_multi_org_flag,'N',l_org_id,aa.org_id)

Line 241: zx_tax_priorities_t (

237: also initialize regime precedence.
238: */
239:
240: INSERT ALL INTO
241: zx_tax_priorities_t (
242: regime_or_tax_flag ,
243: tax_regime_code ,
244: regime_precedence,
245: org_id,

Line 293: zx_tax_priorities_t (

289:
290: BEGIN
291:
292: INSERT ALL INTO
293: zx_tax_priorities_t (
294: regime_or_tax_flag ,
295: tax_id ,
296: tax_code ,
297: tax_precedence ,

Line 332: zx_tax_priorities_t reg

328: 'Y' group_flag,
329: decode(l_multi_org_flag,'N',l_org_id,aa.org_id) org_id
330: FROM ar_tax_group_codes_all a,
331: ar_vat_tax_all_b aa,
332: zx_tax_priorities_t reg
333: WHERE aa.vat_tax_id = a.tax_code_id
334: AND aa.tax_type = reg.tax_type
335: AND decode(l_multi_org_flag,'N',l_org_id,aa.org_id) = reg.org_id
336: AND decode(l_multi_org_flag,'N',l_org_id,aa.org_id) = decode(l_multi_org_flag,'N',l_org_id,a.org_id)

Line 356: zx_tax_priorities_t reg

352: 'N' group_flag,
353: decode(l_multi_org_flag,'N',l_org_id,aa.org_id) org_id
354: FROM ar_tax_group_codes_all a,
355: ar_vat_tax_all_b aa,
356: zx_tax_priorities_t reg
357: WHERE aa.vat_tax_id = a.tax_code_id
358: AND a.compounding_precedence IS NULL
359: AND aa.tax_type = reg.tax_type
360: AND decode(l_multi_org_flag,'N',l_org_id,aa.org_id) = reg.org_id

Line 405: FROM zx_tax_priorities_t

401:
402: /* cursors to set the taxes priorities */
403: CURSOR c_set_priorities IS
404: SELECT org_id, tax_regime_code
405: FROM zx_tax_priorities_t
406: WHERE regime_or_tax_flag ='T'
407: FOR UPDATE OF tax_precedence
408: ORDER BY tax_regime_code,org_id,tax_precedence; --Bug 4524324
409:

Line 412: FROM zx_tax_priorities_t

408: ORDER BY tax_regime_code,org_id,tax_precedence; --Bug 4524324
409:
410: CURSOR c_fix_tax_priorities IS
411: SELECT org_id, tax_precedence, tax_id, ROWID
412: FROM zx_tax_priorities_t
413: WHERE regime_or_tax_flag ='T'
414: ORDER BY tax_regime_code,tax_precedence;
415:
416:

Line 427: FROM zx_tax_priorities_t

423:
424:
425: CURSOR c_get_parent_priority IS
426: SELECT tax_precedence, ROWID
427: FROM zx_tax_priorities_t
428: WHERE tax_id = v_parent_tax
429: AND org_id = v_parent_org;
430:
431: /* cursors to set the regimes priorities */

Line 435: FROM zx_tax_priorities_t

431: /* cursors to set the regimes priorities */
432:
433: CURSOR c_get_parent_reg_prece IS
434: SELECT tax_precedence, ROWID
435: FROM zx_tax_priorities_t
436: WHERE regime_or_tax_flag ='R'
437: AND tax_regime_code = v_parent_regime;
438:
439: CURSOR c_get_child_reg_prece IS

Line 441: FROM zx_tax_priorities_t

437: AND tax_regime_code = v_parent_regime;
438:
439: CURSOR c_get_child_reg_prece IS
440: SELECT tax_precedence, ROWID
441: FROM zx_tax_priorities_t
442: WHERE regime_or_tax_flag ='R'
443: AND tax_regime_code = v_child_regime;
444:
445: BEGIN

Line 463: UPDATE zx_tax_priorities_t

459: END IF;
460:
461: precedence_count:=precedence_count+1;
462:
463: UPDATE zx_tax_priorities_t
464: SET tax_precedence = precedence_count
465: WHERE CURRENT OF c_set_priorities;
466:
467: END LOOP;

Line 500: UPDATE zx_tax_priorities_t

496: v_aux_precedence := v_parent_precedence;
497: v_parent_precedence := v_child_precedence;
498: v_child_precedence := v_aux_precedence;
499:
500: UPDATE zx_tax_priorities_t
501: SET tax_precedence = v_parent_precedence
502: WHERE ROWID = v_parent_tax_rowid;
503:
504: UPDATE zx_tax_priorities_t

Line 504: UPDATE zx_tax_priorities_t

500: UPDATE zx_tax_priorities_t
501: SET tax_precedence = v_parent_precedence
502: WHERE ROWID = v_parent_tax_rowid;
503:
504: UPDATE zx_tax_priorities_t
505: SET tax_precedence = v_child_precedence
506: WHERE ROWID = v_child_tax_rowid;
507:
508: END IF;

Line 528: UPDATE zx_tax_priorities_t

524: v_aux_reg_precedence := v_parent_reg_precedence;
525: v_parent_reg_precedence := v_child_reg_precedence;
526: v_child_reg_precedence := v_aux_reg_precedence;
527:
528: UPDATE zx_tax_priorities_t
529: SET tax_precedence = v_parent_reg_precedence
530: WHERE ROWID = v_parent_reg_rowid;
531:
532: UPDATE zx_tax_priorities_t

Line 532: UPDATE zx_tax_priorities_t

528: UPDATE zx_tax_priorities_t
529: SET tax_precedence = v_parent_reg_precedence
530: WHERE ROWID = v_parent_reg_rowid;
531:
532: UPDATE zx_tax_priorities_t
533: SET tax_precedence = v_child_reg_precedence
534: WHERE ROWID = v_child_reg_rowid;
535:
536: END IF;

Line 561: DELETE zx_tax_priorities_t;

557:
558:
559:
560: DELETE zx_tax_relations_t;
561: DELETE zx_tax_priorities_t;
562: DELETE zx_compound_errors_t;
563: COMMIT;
564:
565: load_regime_list;