APPS.PA_CMT_UTILS dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 114: ap_self_assessed_tax_dist_all sat

110: -- Bug 13602288: Added below select query as a part of self assessed tax enhancement
111: select sum(sat.quantity_invoiced)
112: into l_qty_billed2
113: from po_distributions_all pod,
114: ap_self_assessed_tax_dist_all sat
115: where pod.po_distribution_id = p_po_dist
116: and pod.po_distribution_id = sat.po_distribution_id
117: and NVL(pod.accrue_on_receipt_flag,'N') = 'Y'
118: and sat.pa_addition_flag = 'Y'

Line 408: from ap_self_assessed_tax_dist_all sat,

404: -- Bug 13602288: Added below select query as a part of self assessed tax enhancement
405: select count(*),
406: SUM(sat.pa_quantity*(SUM(nvl(paydist.paid_base_amount,paydist.amount))/(nvl(sat.base_amount,sat.amount))))
407: into l_inv_num2, l_tot_inv_qty2
408: from ap_self_assessed_tax_dist_all sat,
409: ap_payment_hist_dists paydist,
410: ap_invoices_all inv
411: where sat.po_distribution_id = p_po_dist
412: and sat.charge_applicable_to_dist_id is null

Line 449: from ap_self_assessed_tax_dist_all sat,

445: -- Bug 13602288: Added below select query as a part of self assessed tax enhancement
446:
447: select count(*), sum(sat.pa_quantity)
448: into l_inv_num2, l_tot_inv_qty2
449: from ap_self_assessed_tax_dist_all sat,
450: ap_invoices_all inv
451: where sat.po_distribution_id = p_po_dist
452: and sat. line_type_lookup_code <> 'REC_TAX'
453: and nvl(reversal_flag,'N') <> 'Y'

Line 600: from ap_self_assessed_tax_dist_all

596: sum(decode(p_denom_amt_flag,
597: 'Y', amount,
598: 'N', nvl(base_amount,amount)))
599: into l_inv_num2, l_inv_amt2
600: from ap_self_assessed_tax_dist_all
601: where po_distribution_id = p_po_dist
602: and line_type_lookup_code <> 'REC_TAX'
603: and nvl(reversal_flag,'N') <> 'Y'
604: and pa_addition_flag not in ('Z','T','E','Y');

Line 630: from ap_self_assessed_tax_dist_all

626: select sum(decode(p_denom_amt_flag,
627: 'Y', amount,
628: 'N', nvl(base_amount,amount)))
629: into l_inv_amt2
630: from ap_self_assessed_tax_dist_all
631: where po_distribution_id = p_po_dist
632: and invoice_id = p_invoice_id
633: and invoice_distribution_id = p_inv_dist_id
634: and line_type_lookup_code <> 'REC_TAX'

Line 815: from ap_self_assessed_tax_dist_all sat

811: select decode(p_denom_amt_flag,
812: 'Y', sat.amount,
813: 'N', nvl(sat.base_amount,sat.amount))
814: into l_inv_amt2
815: from ap_self_assessed_tax_dist_all sat
816: where sat.invoice_id = p_invoice_id
817: and sat.invoice_distribution_id = p_inv_dist_id ;
818:
819: l_inv_amt:= l_inv_amt + l_inv_amt2; -- Bug 13602288:self assessed tax enhancement