APPS.ARP_PROCESS_WRITEOFF dependencies on AR_APPROVAL_USER_LIMITS

Line 402: FROM ar_approval_user_limits

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

Line 683: p_user_id IN ar_approval_user_limits.user_id%TYPE,

679: | on the receipt.
680: +===========================================================================*/
681: FUNCTION unapplied_amount(p_cash_receipt_id IN NUMBER,
682: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
683: p_user_id IN ar_approval_user_limits.user_id%TYPE,
684: p_request_id IN NUMBER DEFAULT NULL, /*5444407*/
685: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE
686: default NULL,
687: p_amount_from IN NUMBER default null,

Line 736: FROM ar_approval_user_limits

732: SELECT NVL(amount_from,0),
733: NVL(amount_to,0)
734: INTO l_amount_from,
735: l_amount_to
736: FROM ar_approval_user_limits
737: WHERE currency_code = p_currency_code
738: AND user_id = p_user_id
739: AND document_type ='WRTOFF';
740: EXCEPTION