DBA Data[Home] [Help]

APPS.GMS_PA_COSTING_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 547: FROM AP_SELF_ASSESSED_TAX_DIST_ALL apsat

543: WHERE apdist.invoice_distribution_id = g_xface_rec.invoice_distribution_id
544: AND apdist.invoice_id = g_xface_rec.invoice_id
545: union /* BUG 14216205 : Added the union for SAT */
546: select NVL(APSAT.BASE_AMOUNT,APSAT.AMOUNT)
547: FROM AP_SELF_ASSESSED_TAX_DIST_ALL apsat
548: where APSAT.INVOICE_DISTRIBUTION_ID = G_XFACE_REC.INVOICE_DISTRIBUTION_ID
549: AND apsat.invoice_id = g_xface_rec.invoice_id;
550:
551: -- Bug : 5414183

Line 619: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT

615: apd.line_type_lookup_code )
616: union /* BUG 14216205 : Added the union for SAT */
617: SELECT NVL(b.invoice_dist_base_amount , b.invoice_dist_amount) amount
618: from AP_PAYMENT_HIST_DISTS B,
619: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT
620: where B.INVOICE_PAYMENT_ID = G_XFACE_REC.CDL_SYSTEM_REFERENCE4
621: and b.invoice_distribution_id = g_xface_rec.invoice_distribution_id
622: and b.pay_dist_lookup_code = 'DISCOUNT'
623: and APSAT.INVOICE_DISTRIBUTION_ID = B.INVOICE_DISTRIBUTION_ID