APPS.ZX_NEW_SERVICES_PKG dependencies on ZX_TAX_DIST_ID_GT

Line 3145: FROM zx_rec_nrec_dist zd, zx_tax_dist_id_gt zgt

3141: l_chk_tot_dist_amt_tbl num_tbl_type;
3142:
3143: CURSOR get_tax_line_id_cur IS
3144: SELECT tax_line_id
3145: FROM zx_rec_nrec_dist zd, zx_tax_dist_id_gt zgt
3146: WHERE zd.rec_nrec_tax_dist_id = zgt.tax_dist_id;
3147:
3148: -- Preventive check cursor to check if any tax line exists where tax amount
3149: -- of tax line is not equal to the sum of amounts of its distributions

Line 3159: zx_tax_dist_id_gt zgt

3155: zx_rec_nrec_dist zd
3156: WHERE zl.tax_line_id IN
3157: (SELECT zd.tax_line_id
3158: FROM zx_rec_nrec_dist zd,
3159: zx_tax_dist_id_gt zgt
3160: WHERE zd.rec_nrec_tax_dist_id = zgt.tax_dist_id)
3161: AND zd.application_id = zl.application_id
3162: AND zd.entity_code = zl.entity_code
3163: AND zd.event_class_code = zl.event_class_code

Line 3231: AND rec_nrec_tax_dist_id IN (SELECT tax_dist_id FROM zx_tax_dist_id_gt);

3227: AND entity_code = p_transaction_line_rec.entity_code
3228: AND event_class_code = p_transaction_line_rec.event_class_code
3229: AND trx_id = p_transaction_line_rec.trx_id
3230: AND trx_level_type = p_transaction_line_rec.trx_level_type
3231: AND rec_nrec_tax_dist_id IN (SELECT tax_dist_id FROM zx_tax_dist_id_gt);
3232:
3233: IF SQL%ROWCOUNT > 0 THEN
3234: FORALL i IN NVL(l_tax_line_id_tbl.FIRST, 0) .. NVL(l_tax_line_id_tbl.LAST, -1)
3235: UPDATE zx_lines

Line 3328: (SELECT tax_dist_id FROM zx_tax_dist_id_gt)

3324: l_msg_context_info_rec.event_class_code,
3325: l_msg_context_info_rec.trx_id
3326: FROM zx_rec_nrec_dist
3327: WHERE rec_nrec_tax_dist_id IN
3328: (SELECT tax_dist_id FROM zx_tax_dist_id_gt)
3329: AND ROWNUM = 1;
3330: EXCEPTION
3331: WHEN OTHERS THEN
3332: l_msg_context_info_rec.application_id := NULL;