APPS.AP_CANCEL_PKG dependencies on ZX_REC_NREC_DIST

Line 840: zx_rec_nrec_dist zx_dist

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'
844: AND nvl(zx_dist.reverse_flag, 'N') <> 'Y'

Line 853: FROM zx_rec_nrec_dist zx_dist,

849: -- have not been cancelled in case of inclusive tax.
850:
851: SELECT count(*)
852: INTO l_tax_dist_count
853: FROM zx_rec_nrec_dist zx_dist,
854: ap_invoice_distributions ap_dist
855: WHERE ap_dist.invoice_id = p_invoice_id
856: AND ap_dist.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
857: AND nvl(zx_dist.reverse_flag, 'N') <> 'Y'