APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on ZX_REC_NREC_DIST_GT

Line 1303: | ZX_REC_NREC_DIST_GT |

1299:
1300: /* ===========================================================================*
1301: | PROCEDURE Delete_Tax_Distributions: Deletes old tax distributions from |
1302: | ZX_REC_NREC_DIST when new tax distributions are created in |
1303: | ZX_REC_NREC_DIST_GT |
1304: * ===========================================================================*/
1305:
1306: PROCEDURE Delete_Tax_Distributions(
1307: x_return_status OUT NOCOPY VARCHAR2,

Line 2671: FROM ZX_REC_NREC_DIST_GT;

2667: INTERNAL_ORGANIZATION_ID,
2668: DEF_REC_SETTLEMENT_OPTION_CODE,
2669: TAX_JURISDICTION_ID,
2670: ACCOUNT_SOURCE_TAX_RATE_ID
2671: FROM ZX_REC_NREC_DIST_GT;
2672:
2673: IF (g_level_statement >= g_current_runtime_level ) THEN
2674: FND_LOG.STRING(g_level_statement,
2675: 'ZX.PLSQL.ZX_TRL_MANAGE_TAX_PKG.Create_Tax_Distributions',

Line 2684: FROM zx_rec_nrec_dist_gt

2680: UPDATE zx_lines
2681: SET associated_child_frozen_flag = 'Y'
2682: WHERE tax_line_id IN
2683: (SELECT tax_line_id
2684: FROM zx_rec_nrec_dist_gt
2685: WHERE tax_only_line_flag = 'Y'
2686: );
2687: EXCEPTION
2688: WHEN OTHERS THEN

Line 2902: FROM zx_rec_nrec_dist_gt gt

2898: BEGIN
2899: UPDATE zx_rec_nrec_dist zd
2900: SET summary_tax_line_id =
2901: (SELECT summary_tax_line_id
2902: FROM zx_rec_nrec_dist_gt gt
2903: WHERE gt.tax_line_id = zd.tax_line_id
2904: AND gt.trx_line_dist_id = zd.trx_line_dist_id
2905: AND ROWNUM = 1
2906: )

Line 2930: FROM zx_rec_nrec_dist_gt gt

2926: )
2927: )
2928: AND EXISTS
2929: (SELECT summary_tax_line_id
2930: FROM zx_rec_nrec_dist_gt gt
2931: WHERE gt.tax_line_id = zd.tax_line_id
2932: AND gt.trx_line_dist_id = zd.trx_line_dist_id
2933: );
2934: