APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 316: -- brought back to zx_detail_tax_lines_gt (bug 4313177).

312: FROM dual;
313:
314: -- For a update event in quote calls(only PO has such case now),
315: -- no need to Update_Item_Dist_Changed_Flag, since all tax lines have been
316: -- brought back to zx_detail_tax_lines_gt (bug 4313177).
317:
318: IF (p_event_class_rec.tax_event_type_code = 'RE-DISTRIBUTE')
319: AND p_event_class_rec.quote_flag <> 'Y'
320: THEN

Line 3737: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */

3733: --6900725
3734: ORDER BY trx_line_id, trx_level_type, account_source_tax_rate_id nulls first ;
3735:
3736: CURSOR fetch_tax_lines_gt_csr IS
3737: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3738: *
3739: FROM zx_detail_tax_lines_gt
3740: WHERE application_id = p_event_class_rec.application_id
3741: AND entity_code = p_event_class_rec.entity_code

Line 3739: FROM zx_detail_tax_lines_gt

3735:
3736: CURSOR fetch_tax_lines_gt_csr IS
3737: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3738: *
3739: FROM zx_detail_tax_lines_gt
3740: WHERE application_id = p_event_class_rec.application_id
3741: AND entity_code = p_event_class_rec.entity_code
3742: AND event_class_code = p_event_class_rec.event_class_code
3743: AND trx_id = p_event_class_rec.trx_id