APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

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

337: FROM dual;
338:
339: -- For a update event in quote calls(only PO has such case now),
340: -- no need to Update_Item_Dist_Changed_Flag, since all tax lines have been
341: -- brought back to zx_detail_tax_lines_gt (bug 4313177).
342:
343: IF (p_event_class_rec.tax_event_type_code = 'RE-DISTRIBUTE')
344: AND p_event_class_rec.quote_flag <> 'Y'
345: THEN

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

3923: --6900725
3924: ORDER BY trx_line_id, trx_level_type, account_source_tax_rate_id nulls first ;
3925:
3926: CURSOR fetch_tax_lines_gt_csr IS
3927: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3928: *
3929: FROM zx_detail_tax_lines_gt
3930: WHERE application_id = p_event_class_rec.application_id
3931: AND entity_code = p_event_class_rec.entity_code

Line 3929: FROM zx_detail_tax_lines_gt

3925:
3926: CURSOR fetch_tax_lines_gt_csr IS
3927: SELECT /*+ INDEX(ZX_DETAIL_TAX_LINES_GT ZX_DETAIL_TAX_LINES_GT_U1) */
3928: *
3929: FROM zx_detail_tax_lines_gt
3930: WHERE application_id = p_event_class_rec.application_id
3931: AND entity_code = p_event_class_rec.entity_code
3932: AND event_class_code = p_event_class_rec.event_class_code
3933: AND trx_id = p_event_class_rec.trx_id