DBA Data[Home] [Help]

APPS.AP_WEB_PAYMENTS_PKG dependencies on FND_PROFILE

Line 298: IF (nvl(FND_PROFILE.VALUE_SPECIFIC('OIE_CARRY_ADVANCES_FORWARD',NULL,p_resp_id,p_apps_id),'Y') = 'Y' )THEN

294:
295: BEGIN
296:
297: BEGIN
298: IF (nvl(FND_PROFILE.VALUE_SPECIFIC('OIE_CARRY_ADVANCES_FORWARD',NULL,p_resp_id,p_apps_id),'Y') = 'Y' )THEN
299:
300: SELECT SUM(nvl(prepay_amount_remaining,amount))
301: INTO l_prepay_amt_invoiced
302: FROM ap_invoice_distributions aid,ap_invoices ai

Line 362: IF l_prepay_amt_available < 0 OR (nvl(FND_PROFILE.VALUE_SPECIFIC('OIE_CARRY_ADVANCES_FORWARD',NULL,p_resp_id,p_apps_id),'Y') = 'N' AND l_prepay_amt_expensed > 0)THEN

358: END ;
359:
360: l_prepay_amt_available := l_prepay_amt_invoiced - l_prepay_amt_expensed;
361:
362: IF l_prepay_amt_available < 0 OR (nvl(FND_PROFILE.VALUE_SPECIFIC('OIE_CARRY_ADVANCES_FORWARD',NULL,p_resp_id,p_apps_id),'Y') = 'N' AND l_prepay_amt_expensed > 0)THEN
363: l_prepay_amt_available := 0;
364: END IF;
365:
366: RETURN l_prepay_amt_available;