DBA Data[Home] [Help]

APPS.AP_CANCEL_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 839: FROM ap_self_assessed_tax_dist_all asat,

835: -- Bug 6694536. Need to call the etax api to reverse the self assessed tax lines.
836:
837: SELECT count(*)
838: INTO l_self_assess_tax_count
839: FROM ap_self_assessed_tax_dist_all asat,
840: zx_rec_nrec_dist zx_dist
841: WHERE invoice_id = p_invoice_id
842: AND asat.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
843: AND zx_dist.self_assessed_flag = 'Y'