APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))

1111: FROM ap_invoices_all ai
1112: WHERE ai.invoice_id=p_invoice_id
1113: GROUP BY ai.invoice_id,ai.invoice_amount
1114: ,ai.discount_amount_taken, decode(ai.net_of_retainage_flag,'Y',0,
1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))
1116: HAVING (abs(nvl(ai.invoice_amount,0) -nvl(ai.discount_amount_taken,0)
1117: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(ai.invoice_id),0)
1118: + decode(ai.net_of_retainage_flag, 'Y', 0,
1119: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id, ai.org_id),0))

Line 1117: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(ai.invoice_id),0)

1113: GROUP BY ai.invoice_id,ai.invoice_amount
1114: ,ai.discount_amount_taken, decode(ai.net_of_retainage_flag,'Y',0,
1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))
1116: HAVING (abs(nvl(ai.invoice_amount,0) -nvl(ai.discount_amount_taken,0)
1117: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(ai.invoice_id),0)
1118: + decode(ai.net_of_retainage_flag, 'Y', 0,
1119: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id, ai.org_id),0))
1120: )
1121: < abs((nvl(l_pay_amt,0)-nvl(l_prepay_amt,0))

Line 1119: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id, ai.org_id),0))

1115: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id,ai.org_id),0))
1116: HAVING (abs(nvl(ai.invoice_amount,0) -nvl(ai.discount_amount_taken,0)
1117: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(ai.invoice_id),0)
1118: + decode(ai.net_of_retainage_flag, 'Y', 0,
1119: nvl(AP_INVOICES_UTILITY_PKG.GET_RETAINED_TOTAL(ai.invoice_id, ai.org_id),0))
1120: )
1121: < abs((nvl(l_pay_amt,0)-nvl(l_prepay_amt,0))
1122: +((l_amount) + (l_discount_taken))));
1123: