APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_ITM_DISTRIBUTIONS_GT

Line 108: SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1 ZX_ITM_DISTRIBUTIONS_GT_U1) */

104:
105: CURSOR get_item_dist_csr(
106: c_trx_line_id zx_lines.trx_line_id%TYPE,
107: c_trx_level_type zx_lines.trx_level_type%TYPE) IS
108: SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1 ZX_ITM_DISTRIBUTIONS_GT_U1) */
109: trx_line_dist_id,
110: trx_line_id,
111: trx_level_type,
112: dist_level_action,

Line 154: FROM zx_itm_distributions_gt

150: overriding_recovery_rate,
151: -- applied_from_trx_level_type,
152: -- adjusted_doc_trx_level_type,
153: trx_line_dist_date -- AP passes account_date
154: FROM zx_itm_distributions_gt
155: WHERE trx_id = p_event_class_rec.trx_id
156: AND application_id = p_event_class_rec.application_id
157: AND entity_code = p_event_class_rec.entity_code
158: AND event_class_code = p_event_class_rec.event_class_code

Line 498: -- zx_itm_distributions_gt into pl/sql tables

494: END IF;
495: ELSE
496:
497: -- Fetch item distributions of this transaction line from
498: -- zx_itm_distributions_gt into pl/sql tables
499: --
500: OPEN get_item_dist_csr(l_trx_line_id, l_trx_level_type);
501: FETCH get_item_dist_csr BULK COLLECT INTO
502: trx_line_dist_id_tbl,

Line 3565: INSERT INTO zx_itm_distributions_gt(

3561: 'ZX.PLSQL.ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST.BEGIN',
3562: 'ZX_TRD_SERVICES_PUB_PKG.INSERT_ITEM_DIST(+)');
3563: END IF;
3564:
3565: INSERT INTO zx_itm_distributions_gt(
3566: --internal_organization_id,
3567: application_id,
3568: entity_code,
3569: event_class_code,