APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on ZX_TAX_DIST_ID_GT

Line 879: ZX_TAX_DIST_ID_GT ZGT

875: (SELECT summary_tax_line_id
876: FROM ZX_LINES
877: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
878: FROM ZX_REC_NREC_DIST ZD,
879: ZX_TAX_DIST_ID_GT ZGT
880: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID))
881: AND Associated_Child_Frozen_Flag = 'N';
882:
883: */

Line 891: ZX_TAX_DIST_ID_GT ZGT

887: UPDATE ZX_LINES
888: SET SUMMARY_TAX_LINE_ID = NULL
889: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
890: FROM ZX_REC_NREC_DIST ZD,
891: ZX_TAX_DIST_ID_GT ZGT
892: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID)
893: AND ASSOCIATED_CHILD_FROZEN_FLAG = 'N';
894: --
895: -- re-perform summarization for all tax lines

Line 3165: FROM ZX_TAX_DIST_ID_GT);

3161: SET Freeze_Flag = 'Y',
3162: event_type_code = p_event_class_rec.event_type_code,
3163: tax_event_type_code = p_event_class_rec.tax_event_type_code
3164: WHERE REC_NREC_TAX_DIST_ID IN (SELECT TAX_DIST_ID
3165: FROM ZX_TAX_DIST_ID_GT);
3166:
3167: */
3168: -- Bug 6335649, In cases where Recovery is 100% Recoverable, in ZX_REC_NREC_DIST we have both REC and NONREC(0 amount)lines.
3169: -- When we call ZX_TRD_INTERNAL_SERVICES_PVT.calc_tax_dist for the second time computation,

Line 3180: (SELECT TAX_DIST_ID FROM ZX_TAX_DIST_ID_GT)

3176: tax_event_type_code = p_event_class_rec.tax_event_type_code
3177: WHERE tax_line_id IN (SELECT tax_line_id
3178: FROM zx_rec_nrec_dist
3179: WHERE rec_nrec_tax_dist_id IN
3180: (SELECT TAX_DIST_ID FROM ZX_TAX_DIST_ID_GT)
3181: )
3182: AND application_id = p_event_class_rec.application_id
3183: ;
3184:

Line 3192: ZX_TAX_DIST_ID_GT ZGT

3188: tax_event_type_code = p_event_class_rec.tax_event_type_code,
3189: doc_event_status = p_event_class_rec.doc_status_code
3190: WHERE TAX_LINE_ID IN (SELECT ZD.TAX_LINE_ID
3191: FROM ZX_REC_NREC_DIST ZD ,
3192: ZX_TAX_DIST_ID_GT ZGT
3193: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID);
3194:
3195: -- Bug 6456915: Associated_child_frozen_flag has been removed from grouping columns for summary tax lines
3196: --No need to regenerate summary tax lines here

Line 3210: ZX_TAX_DIST_ID_GT ZGT

3206: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
3207: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
3208: AND TRX_ID IN(SELECT ZD.trx_id
3209: FROM ZX_REC_NREC_DIST ZD ,
3210: ZX_TAX_DIST_ID_GT ZGT
3211: WHERE ZD.REC_NREC_TAX_DIST_ID = ZGT.TAX_DIST_ID);
3212:
3213: IF p_event_class_rec.retain_summ_tax_line_id_flag = 'Y' THEN
3214: --

Line 4008: (SELECT tax_dist_id FROM zx_tax_dist_id_gt);

4004:
4005: UPDATE zx_rec_nrec_dist
4006: SET gl_date = p_gl_date
4007: WHERE rec_nrec_tax_dist_id IN
4008: (SELECT tax_dist_id FROM zx_tax_dist_id_gt);
4009:
4010: IF (g_level_procedure >= g_current_runtime_level ) THEN
4011: FND_LOG.STRING(g_level_procedure,
4012: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Update_GL_Date.END',