APPS.ZX_TRL_PUB_PKG dependencies on ZX_TRX_HEADERS_GT

Line 1445: -- bug 14198788 driving queries from zx_trx_headers_gt

1441: l_msg_context_info_rec ZX_API_PUB.CONTEXT_INFO_REC_TYPE;
1442: l_prev_trx_id NUMBER;
1443:
1444: -- Cursors added for Frozen Tax Deleted Check --
1445: -- bug 14198788 driving queries from zx_trx_headers_gt
1446: CURSOR get_deleted_frzn_dist IS
1447: SELECT /*+ leading(headers_gt) use_nl(AID) */
1448: DISTINCT
1449: aid.invoice_id trx_id,

Line 1453: zx_trx_headers_gt headers_gt

1449: aid.invoice_id trx_id,
1450: aid.detail_tax_dist_id tax_dist_id,
1451: aid.summary_tax_line_id summary_tax_line_id
1452: FROM ap_invoice_distributions_all aid,
1453: zx_trx_headers_gt headers_gt
1454: WHERE headers_gt.event_class_code = p_event_class_rec.event_class_code
1455: AND headers_gt.entity_code = p_event_class_rec.entity_code
1456: AND headers_gt.application_id = p_event_class_rec.application_id
1457: AND aid.invoice_id = headers_gt.trx_id

Line 1468: -- bug 14198788 driving queries from zx_trx_headers_gt

1464: FROM zx_rec_nrec_dist zd
1465: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id
1466: AND NVL(zd.self_assessed_flag, 'N') = 'N');
1467:
1468: -- bug 14198788 driving queries from zx_trx_headers_gt
1469: CURSOR get_deleted_frzn_sa_dist IS
1470: SELECT /*+ leading(headers_gt) use_nl(ASAD) */
1471: DISTINCT
1472: asad.invoice_id trx_id,

Line 1476: zx_trx_headers_gt headers_gt

1472: asad.invoice_id trx_id,
1473: asad.detail_tax_dist_id tax_dist_id,
1474: asad.summary_tax_line_id summary_tax_line_id
1475: FROM ap_self_assessed_tax_dist_all asad,
1476: zx_trx_headers_gt headers_gt
1477: WHERE headers_gt.event_class_code = p_event_class_rec.event_class_code
1478: AND headers_gt.entity_code = p_event_class_rec.entity_code
1479: AND headers_gt.application_id = p_event_class_rec.application_id
1480: AND asad.invoice_id = headers_gt.trx_id