eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_LINES

Line 20: -- Bug 5417887: Tables to hold zx_lines_det_factor_attributes to avoid any further fetch on it.

16:
17: NUMBER_DUMMY CONSTANT NUMBER(15):= -999999999999999;
18:
19:
20: -- Bug 5417887: Tables to hold zx_lines_det_factor_attributes to avoid any further fetch on it.
21: TYPE varchar_30_idx_bi_tbl_type is table of VARCHAR2(30) index by BINARY_INTEGER;
22: record_type_code_tbl varchar_30_idx_bi_tbl_type;
23: line_level_action_tbl varchar_30_idx_bi_tbl_type;
24:

Line 71: FROM ZX_LINES

67: SELECT tax_provider_id,
68: tax_regime_code
69: INTO x_migrated_tax_provider_id,
70: x_migrated_tax_regime_code
71: FROM ZX_LINES
72: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
73: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
74: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
75: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)

Line 91: FROM ZX_LINES

87: SELECT tax_provider_id,
88: tax_regime_code
89: INTO x_migrated_tax_provider_id,
90: x_migrated_tax_regime_code
91: FROM ZX_LINES
92: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
93: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
94: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
95: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_index)

Line 219: prev_application_id zx_lines_det_factors.application_id%type;

215:
216: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;

Line 220: prev_entity_code zx_lines_det_factors.entity_code%type;

216: prev_tax_regime_code zx_regimes_b.tax_regime_code%type;
217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;

Line 221: prev_event_class_code zx_lines_det_factors.event_class_code%type;

217: l_tax_regime_id zx_regimes_b.tax_regime_id%type;
218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;

Line 222: prev_trx_id zx_lines_det_factors.trx_id%type;

218:
219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
226: l_historical_flag VARCHAR2(1);

Line 223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;

219: prev_application_id zx_lines_det_factors.application_id%type;
220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
226: l_historical_flag VARCHAR2(1);
227: l_ptnr_exemption_indx BINARY_INTEGER;

Line 224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;

220: prev_entity_code zx_lines_det_factors.entity_code%type;
221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
226: l_historical_flag VARCHAR2(1);
227: l_ptnr_exemption_indx BINARY_INTEGER;
228: l_tax_account_source_tax ZX_TAXES_B.TAX_ACCOUNT_SOURCE_TAX%TYPE;

Line 225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;

221: prev_event_class_code zx_lines_det_factors.event_class_code%type;
222: prev_trx_id zx_lines_det_factors.trx_id%type;
223: prev_trx_line_id zx_lines_det_factors.trx_line_id%type;
224: prev_trx_level_type zx_lines_det_factors.trx_level_type%type;
225: l_lines_det_fact_rec zx_lines_det_factors%rowtype;
226: l_historical_flag VARCHAR2(1);
227: l_ptnr_exemption_indx BINARY_INTEGER;
228: l_tax_account_source_tax ZX_TAXES_B.TAX_ACCOUNT_SOURCE_TAX%TYPE;
229:

Line 276: FROM zx_lines_det_factors

272: ELSE
273: BEGIN
274: SELECT *
275: INTO l_lines_det_fact_rec
276: FROM zx_lines_det_factors
277: WHERE application_id = p_event_class_rec.application_id
278: AND entity_code = p_event_class_rec.entity_code
279: AND event_class_code = p_event_class_rec.event_class_code
280: AND trx_id = p_event_class_rec.trx_id

Line 338: FROM ZX_LINES_DET_FACTORS

334: ' trx_level_type = ' || ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.trx_level_type(p_ptnr_tax_line_ind));
335: END IF;
336: BEGIN
337: SELECT historical_flag INTO l_historical_flag
338: FROM ZX_LINES_DET_FACTORS
339: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
340: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
341: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
342: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 357: FROM zx_lines

353: IF NVL(l_historical_flag,'N') = 'N' THEN
354: BEGIN
355: SELECT tax_line_id
356: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind)
357: FROM zx_lines
358: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
359: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
360: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
361: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 375: FROM zx_lines

371: ELSE
372: BEGIN
373: SELECT tax_line_id
374: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_tax_line_id(p_ptnr_tax_line_ind)
375: FROM zx_lines
376: WHERE application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_application_id(p_ptnr_tax_line_ind)
377: AND entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_entity_code(p_ptnr_tax_line_ind)
378: AND event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_event_class_code(p_ptnr_tax_line_ind)
379: AND trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.adjusted_doc_trx_id(p_ptnr_tax_line_ind)

Line 856: FROM ZX_LINES_DET_FACTORS

852: --APPLIED_FROM_DOCUMENT - check if original document is migrated
853: BEGIN
854: SELECT nvl(partner_migrated_flag, 'N') -- Bug 5007293
855: INTO l_ptnr_migrated_flag
856: FROM ZX_LINES_DET_FACTORS
857: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
858: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
859: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
860: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)

Line 870: --APPLIED_FROM_DOCUMENT - migrated: get information of regimes from ZX_LINES

866: l_ptnr_migrated_flag := 'N';
867: END;
868:
869: IF l_ptnr_migrated_flag = 'Y' THEN
870: --APPLIED_FROM_DOCUMENT - migrated: get information of regimes from ZX_LINES
871: get_migrated_doc_info (p_trx_line_index,
872: l_migrated_tax_provider_id,
873: l_migrated_tax_regime_code,
874: l_migrated_tax_regime_id,

Line 958: FROM ZX_LINES_DET_FACTORS

954: --ADJUSTED_DOC - check if original document is migrated
955: BEGIN
956: SELECT nvl(partner_migrated_flag, 'N') -- Bug 5007293
957: INTO l_ptnr_migrated_flag
958: FROM ZX_LINES_DET_FACTORS
959: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
960: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
961: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
962: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(p_trx_line_index)

Line 970: --ADJUSTED DOC - migrated: get information of regimes from ZX_LINES

966: WHEN no_data_found THEN
967: l_ptnr_migrated_flag := 'N';
968: END;
969: IF l_ptnr_migrated_flag = 'Y' THEN
970: --ADJUSTED DOC - migrated: get information of regimes from ZX_LINES
971: get_migrated_doc_info (p_trx_line_index,
972: l_migrated_tax_provider_id,
973: l_migrated_tax_regime_code,
974: l_migrated_tax_regime_id,

Line 1530: FROM ZX_LINES_DET_FACTORS lines

1526: sysdate,
1527: fnd_global.user_id,
1528: sysdate,
1529: fnd_global.user_id
1530: FROM ZX_LINES_DET_FACTORS lines
1531: WHERE application_id = p_event_class_rec.application_id
1532: AND entity_code = p_event_class_rec.entity_code
1533: AND event_class_code = p_event_class_rec.event_class_code
1534: AND trx_id = p_event_class_rec.trx_id

Line 1598: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593

1594: l_establishment_number ZX_TRX_PRE_PROC_OPTIONS_GT.establishment_number%type; -- Bug 5139731
1595: l_application_short_name FND_APPLICATION.application_short_name%type;
1596: -- Bug# 4769082
1597: l_cnt_of_options_gt NUMBER;
1598: l_hq_estb_ptp_id ZX_LINES_DET_FACTORS.hq_estb_party_tax_prof_id%type; -- Bug 5090593
1599: l_party_id ZX_PARTY_TAX_PROFILE.party_id%type; -- Bug 5090593
1600: l_tax_provider_id NUMBER; -- Bug 5090593
1601:
1602: BEGIN

Line 1696: FROM zx_lines_det_factors

1692: SELECT line_level_action,
1693: hq_estb_party_tax_prof_id
1694: INTO l_line_level_action,
1695: l_hq_estb_ptp_id
1696: FROM zx_lines_det_factors
1697: WHERE application_id = p_event_class_rec.application_id
1698: AND entity_code = p_event_class_rec.entity_code
1699: AND event_class_code = p_event_class_rec.event_class_code
1700: AND trx_id = p_event_class_rec.trx_id

Line 1905: FROM ZX_LINES_DET_FACTORS

1901:
1902: --Currencies can be passed at either the header level/line level
1903: CURSOR document_currency_csr IS
1904: SELECT nvl(trx_line_currency_code,trx_currency_code) trx_currency_code
1905: FROM ZX_LINES_DET_FACTORS
1906: WHERE application_id = p_event_class_rec.application_id
1907: AND entity_code = p_event_class_rec.entity_code
1908: AND event_class_code = p_event_class_rec.event_class_code
1909: AND trx_id = p_event_class_rec.trx_id;

Line 2094: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)

2090: (c_tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
2091: c_tax ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2092: c_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2093: c_tax_class ZX_RATES_B.TAX_CLASS%TYPE,
2094: c_tax_determine_date ZX_LINES.TAX_DETERMINE_DATE%TYPE)
2095: IS
2096: SELECT rate.tax_rate_code,
2097: rate.rate_type_code,
2098: rate.tax_rate_id

Line 2476: FROM ZX_LINES tax

2472: tax.line_amt
2473: INTO l_prepay_tax_rate,
2474: l_prepay_tax_amt,
2475: l_prepay_line_amt
2476: FROM ZX_LINES tax
2477: WHERE tax.application_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.applied_from_application_id(ptnr_tax_line_index)
2478: AND tax.entity_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.applied_from_entity_code(ptnr_tax_line_index)
2479: AND tax.event_class_code = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.applied_from_event_class_code(ptnr_tax_line_index)
2480: AND tax.trx_id = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.applied_from_trx_id(ptnr_tax_line_index)

Line 2660: ZX_LINES_S.nextval,

2656: last_update_login
2657:
2658: )
2659: VALUES (--ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_line_id(i),
2660: ZX_LINES_S.nextval,
2661: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.internal_organization_id(i),
2662: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.application_id(i),
2663: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.entity_code(i),
2664: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.event_class_code(i),

Line 2776: -- Update THRESHOLD_INDICATOR_FLAG, partner migrated_flag on ZX_LINES_DET_FACTORS for the whole document.

2772: ' Exception while Populate zx_detail_tax_lines_gt: ' || sqlerrm);
2773: END IF;
2774: END;
2775:
2776: -- Update THRESHOLD_INDICATOR_FLAG, partner migrated_flag on ZX_LINES_DET_FACTORS for the whole document.
2777: IF l_threshold_indicator_flag = 'Y' OR l_partner_migrated_flag = 'N' THEN
2778: UPDATE zx_lines_det_factors
2779: SET threshold_indicator_flag = nvl(l_threshold_indicator_flag, threshold_indicator_flag),
2780: partner_migrated_flag = nvl(l_partner_migrated_flag, partner_migrated_flag),

Line 2778: UPDATE zx_lines_det_factors

2774: END;
2775:
2776: -- Update THRESHOLD_INDICATOR_FLAG, partner migrated_flag on ZX_LINES_DET_FACTORS for the whole document.
2777: IF l_threshold_indicator_flag = 'Y' OR l_partner_migrated_flag = 'N' THEN
2778: UPDATE zx_lines_det_factors
2779: SET threshold_indicator_flag = nvl(l_threshold_indicator_flag, threshold_indicator_flag),
2780: partner_migrated_flag = nvl(l_partner_migrated_flag, partner_migrated_flag),
2781: line_amt_includes_tax_flag = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.line_amt_includes_tax_flag(1)
2782: WHERE application_id = p_event_class_rec.application_id

Line 2850: l_last_manual_entry zx_lines.last_manual_entry%type;

2846: ) IS
2847:
2848: l_api_name CONSTANT VARCHAR2(30) := 'PTNR_POST_PROC_SYNC_TAX';
2849: l_context_info_rec ZX_API_PUB.context_info_rec_type;
2850: l_last_manual_entry zx_lines.last_manual_entry%type;
2851: l_tax_line_id zx_lines.tax_line_id%type; -- Bug 4908196
2852: l_return_status VARCHAR2(1);
2853:
2854: BEGIN

Line 2851: l_tax_line_id zx_lines.tax_line_id%type; -- Bug 4908196

2847:
2848: l_api_name CONSTANT VARCHAR2(30) := 'PTNR_POST_PROC_SYNC_TAX';
2849: l_context_info_rec ZX_API_PUB.context_info_rec_type;
2850: l_last_manual_entry zx_lines.last_manual_entry%type;
2851: l_tax_line_id zx_lines.tax_line_id%type; -- Bug 4908196
2852: l_return_status VARCHAR2(1);
2853:
2854: BEGIN
2855: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2872: FROM ZX_LINES tax

2868: SELECT tax.last_manual_entry
2869: , tax.tax_line_id
2870: INTO l_last_manual_entry
2871: , l_tax_line_id
2872: FROM ZX_LINES tax
2873: WHERE tax.application_id = p_event_class_rec.application_id
2874: AND tax.entity_code = p_event_class_rec.entity_code
2875: AND tax.event_class_code = p_event_class_rec.event_class_code
2876: AND tax.trx_id = p_event_class_rec.trx_id

Line 2886: UPDATE ZX_LINES

2882:
2883: IF l_last_manual_entry = 'TAX_AMOUNT' THEN
2884: IF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage is not null OR
2885: ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount is not null THEN
2886: UPDATE ZX_LINES
2887: SET tax_rate = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage,
2888: taxable_amt = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount
2889: WHERE tax_line_id = l_tax_line_id;
2890: END IF;

Line 2898: UPDATE ZX_LINES

2894: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'The tax partner cannot modify an overridden tax rate');
2896: END IF;
2897: ELSIF ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount is not null THEN
2898: UPDATE ZX_LINES
2899: SET taxable_amt = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount
2900: WHERE tax_line_id = l_tax_line_id;
2901: END IF;
2902: END IF; --last_manual_entry

Line 2904: UPDATE ZX_LINES

2900: WHERE tax_line_id = l_tax_line_id;
2901: END IF;
2902: END IF; --last_manual_entry
2903: ELSE
2904: UPDATE ZX_LINES
2905: SET tax_rate = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).tax_rate_percentage,
2906: taxable_amt = ZX_PTNR_SRVC_INTGRTN_PKG.g_sync_tax_lines_tbl(i).taxable_amount
2907: WHERE application_id = p_event_class_rec.application_id
2908: AND entity_code = p_event_class_rec.entity_code

Line 2949: SELECT /+ INDEX (TAX ZX_LINES_U1) /

2945: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2946: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
2947: END IF;
2948:
2949: SELECT /*+ INDEX (TAX ZX_LINES_U1) */
2950: sum(nvl(tax.tax_amt,0))
2951: INTO l_tax_amount
2952: FROM ZX_LINES tax
2953: WHERE tax.application_id = p_application_id

Line 2952: FROM ZX_LINES tax

2948:
2949: SELECT /*+ INDEX (TAX ZX_LINES_U1) */
2950: sum(nvl(tax.tax_amt,0))
2951: INTO l_tax_amount
2952: FROM ZX_LINES tax
2953: WHERE tax.application_id = p_application_id
2954: AND tax.entity_code = p_entity_code
2955: AND tax.event_class_code = p_event_class_code
2956: AND tax.trx_id = p_trx_id