APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on ZX_REC_NREC_DIST_GT

Line 1570: | ZX_REC_NREC_DIST_GT |

1566:
1567: /* ===========================================================================*
1568: | PROCEDURE Delete_Tax_Distributions: Deletes old tax distributions from |
1569: | ZX_REC_NREC_DIST when new tax distributions are created in |
1570: | ZX_REC_NREC_DIST_GT |
1571: * ===========================================================================*/
1572:
1573: PROCEDURE Delete_Tax_Distributions(
1574: x_return_status OUT NOCOPY VARCHAR2,

Line 2945: FROM ZX_REC_NREC_DIST_GT;

2941: INTERNAL_ORGANIZATION_ID,
2942: DEF_REC_SETTLEMENT_OPTION_CODE,
2943: TAX_JURISDICTION_ID,
2944: ACCOUNT_SOURCE_TAX_RATE_ID
2945: FROM ZX_REC_NREC_DIST_GT;
2946:
2947: IF (g_level_statement >= g_current_runtime_level ) THEN
2948: FND_LOG.STRING(g_level_statement,
2949: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Tax_Distributions',

Line 2958: FROM zx_rec_nrec_dist_gt

2954: UPDATE zx_lines
2955: SET associated_child_frozen_flag = 'Y'
2956: WHERE tax_line_id IN
2957: (SELECT tax_line_id
2958: FROM zx_rec_nrec_dist_gt
2959: WHERE tax_only_line_flag = 'Y'
2960: );
2961: EXCEPTION
2962: WHEN OTHERS THEN

Line 3184: FROM zx_rec_nrec_dist_gt gt

3180: BEGIN
3181: UPDATE zx_rec_nrec_dist zd
3182: SET summary_tax_line_id =
3183: (SELECT summary_tax_line_id
3184: FROM zx_rec_nrec_dist_gt gt
3185: WHERE gt.tax_line_id = zd.tax_line_id
3186: AND gt.trx_line_dist_id = zd.trx_line_dist_id
3187: AND ROWNUM = 1
3188: )

Line 3214: FROM ZX_REC_NREC_DIST_GT GT);

3210: )
3211: AND (ZD.TAX_LINE_ID, ZD.TRX_LINE_DIST_ID) IN (
3212: SELECT /*+ LEADING(GT) CARDINALITY(GT 1) */
3213: GT.TAX_LINE_ID, GT.TRX_LINE_DIST_ID
3214: FROM ZX_REC_NREC_DIST_GT GT);
3215:
3216: IF (g_level_statement >= g_current_runtime_level ) THEN
3217: FND_LOG.STRING(g_level_statement,
3218: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Delete_Dist_Marked_For_Delete',