APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on ZX_TAX_DIST_ID_GT

Line 950: ZX_TAX_DIST_ID_GT ZGT

946: (SELECT summary_tax_line_id
947: FROM ZX_LINES
948: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
949: FROM ZX_REC_NREC_DIST ZD,
950: ZX_TAX_DIST_ID_GT ZGT
951: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID))
952: AND Associated_Child_Frozen_Flag = 'N';
953:
954: */

Line 962: ZX_TAX_DIST_ID_GT ZGT

958: UPDATE ZX_LINES
959: SET SUMMARY_TAX_LINE_ID = NULL
960: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
961: FROM ZX_REC_NREC_DIST ZD,
962: ZX_TAX_DIST_ID_GT ZGT
963: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID)
964: AND ASSOCIATED_CHILD_FROZEN_FLAG = 'N';
965: --
966: -- re-perform summarization for all tax lines

Line 3432: FROM ZX_TAX_DIST_ID_GT);

3428: SET Freeze_Flag = 'Y',
3429: event_type_code = p_event_class_rec.event_type_code,
3430: tax_event_type_code = p_event_class_rec.tax_event_type_code
3431: WHERE REC_NREC_TAX_DIST_ID IN (SELECT TAX_DIST_ID
3432: FROM ZX_TAX_DIST_ID_GT);
3433:
3434: */
3435: -- Bug 6335649, In cases where Recovery is 100% Recoverable, in ZX_REC_NREC_DIST we have both REC and NONREC(0 amount)lines.
3436: -- When we call ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist for the second time computation,

Line 3447: (SELECT TAX_DIST_ID FROM ZX_TAX_DIST_ID_GT)

3443: tax_event_type_code = p_event_class_rec.tax_event_type_code
3444: WHERE tax_line_id IN (SELECT tax_line_id
3445: FROM zx_rec_nrec_dist
3446: WHERE rec_nrec_tax_dist_id IN
3447: (SELECT TAX_DIST_ID FROM ZX_TAX_DIST_ID_GT)
3448: )
3449: AND application_id = p_event_class_rec.application_id;
3450:
3451: UPDATE ZX_LINES ZL

Line 3458: ZX_TAX_DIST_ID_GT ZGT

3454: tax_event_type_code = p_event_class_rec.tax_event_type_code,
3455: doc_event_status = p_event_class_rec.doc_status_code
3456: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
3457: FROM ZX_REC_NREC_DIST ZD ,
3458: ZX_TAX_DIST_ID_GT ZGT
3459: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID);
3460:
3461: -- Bug 6456915: Associated_child_frozen_flag has been removed from grouping columns for summary tax lines
3462: --No need to regenerate summary tax lines here

Line 3476: ZX_TAX_DIST_ID_GT ZGT

3472: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
3473: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
3474: AND TRX_ID IN(SELECT ZD.trx_id
3475: FROM ZX_REC_NREC_DIST ZD ,
3476: ZX_TAX_DIST_ID_GT ZGT
3477: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID);
3478:
3479: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
3480: --

Line 4275: (SELECT tax_dist_id FROM zx_tax_dist_id_gt);

4271: UPDATE zx_rec_nrec_dist
4272: SET gl_date = p_gl_date,
4273: orig_gl_date = gl_date
4274: WHERE rec_nrec_tax_dist_id IN
4275: (SELECT tax_dist_id FROM zx_tax_dist_id_gt);
4276:
4277: IF (g_level_procedure >= g_current_runtime_level ) THEN
4278: FND_LOG.STRING(g_level_procedure,
4279: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Update_GL_Date.END',