APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on ZX_TRX_HEADERS_GT

Line 1289: -- bug 14198788 driving queries from zx_trx_headers_gt

1285: l_prev_trx_id NUMBER;
1286: l_context_info_rec ZX_API_PUB.context_info_rec_type;
1287:
1288: -- Cursors added for Frozen Tax Deleted Check --
1289: -- bug 14198788 driving queries from zx_trx_headers_gt
1290: CURSOR get_deleted_frzn_dist IS
1291: SELECT /*+ leading(headers_gt) use_nl(AID) */
1292: aid.invoice_id trx_id,
1293: aid.detail_tax_dist_id tax_dist_id,

Line 1296: zx_trx_headers_gt headers_gt

1292: aid.invoice_id trx_id,
1293: aid.detail_tax_dist_id tax_dist_id,
1294: aid.summary_tax_line_id summary_tax_line_id
1295: FROM ap_invoice_distributions_all aid,
1296: zx_trx_headers_gt headers_gt
1297: WHERE headers_gt.event_class_code = p_event_class_rec.event_class_code
1298: AND headers_gt.entity_code = p_event_class_rec.entity_code
1299: AND headers_gt.application_id = p_event_class_rec.application_id
1300: AND aid.invoice_id = headers_gt.trx_id

Line 1311: -- bug 14198788 driving queries from zx_trx_headers_gt

1307: FROM zx_rec_nrec_dist zd
1308: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id
1309: AND NVL(zd.self_assessed_flag, 'N') = 'N');
1310:
1311: -- bug 14198788 driving queries from zx_trx_headers_gt
1312: CURSOR get_deleted_frzn_sa_dist IS
1313: SELECT /*+ leading(headers_gt) use_nl(ASAD) */
1314: asad.invoice_id trx_id,
1315: asad.detail_tax_dist_id tax_dist_id,

Line 1318: zx_trx_headers_gt headers_gt

1314: asad.invoice_id trx_id,
1315: asad.detail_tax_dist_id tax_dist_id,
1316: asad.summary_tax_line_id summary_tax_line_id
1317: FROM ap_self_assessed_tax_dist_all asad,
1318: zx_trx_headers_gt headers_gt
1319: WHERE headers_gt.event_class_code = p_event_class_rec.event_class_code
1320: AND headers_gt.entity_code = p_event_class_rec.entity_code
1321: AND headers_gt.application_id = p_event_class_rec.application_id
1322: AND asad.invoice_id = headers_gt.trx_id