APPS.ZX_ON_FLY_TRX_UPGRADE_PKG dependencies on ZX_LINES_DET_FACTORS

Line 230: -- exists in the zx_lines_det_factors table.

226: -- NOTE
227: -- case 1: called from ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines(),
228: -- get_tax_lines_from_adjusted/applied():
229: -- trx_line_id in the rec is passed, need to check if the trx_line_id
230: -- exists in the zx_lines_det_factors table.
231: -- case 2: called from ZX_TRL_PUB_PKG.document_level_changes()
232: -- trx level update, if there is any trx line exist for the trx_id,
233: -- the trx is regarded as alreayd migrated.
234: --

Line 257: FROM zx_lines_det_factors

253:
254: x_trx_migrated_b := TRUE;
255: IF p_upg_trx_info_rec.TRX_LINE_ID IS NOT NULL THEN
256: SELECT count(*) into l_count
257: FROM zx_lines_det_factors
258: WHERE application_id = p_upg_trx_info_rec.application_id
259: AND event_class_code = p_upg_trx_info_rec.event_class_code
260: AND entity_code = p_upg_trx_info_rec.entity_code
261: AND trx_id = p_upg_trx_info_rec.trx_id

Line 266: FROM zx_lines_det_factors

262: AND trx_line_id = p_upg_trx_info_rec.trx_line_id
263: AND trx_level_type = p_upg_trx_info_rec.trx_level_type;
264: ELSE
265: SELECT count(*) into l_count
266: FROM zx_lines_det_factors
267: WHERE application_id = p_upg_trx_info_rec.application_id
268: AND event_class_code = p_upg_trx_info_rec.event_class_code
269: AND entity_code = p_upg_trx_info_rec.entity_code
270: AND trx_id = p_upg_trx_info_rec.trx_id;