APPS.CSE_IPV_FA_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 721: FROM AP_SELF_ASSESSED_TAX_DIST_all asstda1

717: UNION
718: -- To get self-assessed tax 13917406
719: SELECT asstda.invoice_id, asstda.distribution_line_number, asstda.unit_price,
720: decode(asstda.line_type_lookup_code,'NONREC_TAX', (SELECT asstda.quantity_invoiced
721: FROM AP_SELF_ASSESSED_TAX_DIST_all asstda1
722: WHERE asstda1.invoice_distribution_id = asstda.charge_applicable_to_dist_id),aila.quantity_invoiced) quantity_invoiced,
723: asstda.invoice_distribution_id,
724: asstda.line_type_lookup_code invoice_distribution_type,
725: asstda.po_distribution_id po_distribution_id,

Line 732: FROM AP_SELF_ASSESSED_TAX_DIST_all asstda,

728: NVL(asstda.base_amount,nvl(asstda.amount, 0)) price_variance,
729: aila.inventory_item_id,
730: aila.org_id,
731: asstda.SELF_ASSESSED_FLAG as self_assessed_flag
732: FROM AP_SELF_ASSESSED_TAX_DIST_all asstda,
733: --ap_invoice_distributions_all aida,
734: ap_invoice_lines_all aila,
735: ap_invoices_all aia
736: WHERE asstda.line_type_lookup_code IN ('NONREC_TAX')

Line 1021: -- Updating ap_self_assessed_tax_dist_all table

1017: debug('invoice_distribution_id : '||invoice_rec.invoice_distribution_id);
1018: debug('Processed successfully. updating ap_invoice_distributions_all.assets_addition_flag = Y');
1019: END IF;
1020:
1021: -- Updating ap_self_assessed_tax_dist_all table
1022: IF l_processed_flag = 'Y' AND NVL(invoice_rec.self_assessed_flag,'N') = 'Y' THEN
1023: UPDATE ap_self_assessed_tax_dist_all
1024: SET assets_addition_flag = 'Y',
1025: request_id = l_conc_request_id

Line 1023: UPDATE ap_self_assessed_tax_dist_all

1019: END IF;
1020:
1021: -- Updating ap_self_assessed_tax_dist_all table
1022: IF l_processed_flag = 'Y' AND NVL(invoice_rec.self_assessed_flag,'N') = 'Y' THEN
1023: UPDATE ap_self_assessed_tax_dist_all
1024: SET assets_addition_flag = 'Y',
1025: request_id = l_conc_request_id
1026: WHERE invoice_distribution_id = invoice_rec.invoice_distribution_id
1027: AND assets_addition_flag <>'Y';

Line 1030: debug('Processed successfully. updating ap_self_assessed_tax_dist_all.assets_addition_flag = Y');

1026: WHERE invoice_distribution_id = invoice_rec.invoice_distribution_id
1027: AND assets_addition_flag <>'Y';
1028:
1029: debug('invoice_distribution_id : '||invoice_rec.invoice_distribution_id);
1030: debug('Processed successfully. updating ap_self_assessed_tax_dist_all.assets_addition_flag = Y');
1031: END IF;
1032:
1033:
1034: END IF; --IF NVL(invoice_rec.po_distribution_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN -- Added for bug 13770784