APPS.ARP_PROCESS_WRITEOFF dependencies on AR_APPROVAL_USER_LIMITS

Line 398: FROM ar_approval_user_limits

394: SELECT NVL(amount_from,0),
395: NVL(amount_to,0)
396: INTO l_amount_from,
397: l_amount_to
398: FROM ar_approval_user_limits
399: WHERE currency_code = l_receipt_currency_code
400: AND user_id = arp_global.user_id
401: AND document_type ='WRTOFF';
402: EXCEPTION

Line 678: p_user_id IN ar_approval_user_limits.user_id%TYPE,

674: | on the receipt.
675: +===========================================================================*/
676: FUNCTION unapplied_amount(p_cash_receipt_id IN NUMBER,
677: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
678: p_user_id IN ar_approval_user_limits.user_id%TYPE,
679: p_request_id IN NUMBER DEFAULT NULL, /*5444407*/
680: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE
681: default NULL,
682: p_amount_from IN NUMBER default null,

Line 731: FROM ar_approval_user_limits

727: SELECT NVL(amount_from,0),
728: NVL(amount_to,0)
729: INTO l_amount_from,
730: l_amount_to
731: FROM ar_approval_user_limits
732: WHERE currency_code = p_currency_code
733: AND user_id = p_user_id
734: AND document_type ='WRTOFF';
735: EXCEPTION