DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on AR_APPROVAL_USER_LIMITS

Line 622: FROM ar_approval_user_limits aul

618: l_currency_code VARCHAR2(30);
619:
620: CURSOR c1 IS
621: SELECT count(*)
622: FROM ar_approval_user_limits aul
623: WHERE aul.reason_code = l_reason_code
624: AND aul.currency_code = l_currency_code
625: AND aul.primary_flag = p_primary_flag
626: AND user_id = p_employee_id

Line 3511: FROM ar_approval_user_limits aul

3507: END IF;
3508: ----------------------------------------------------------
3509:
3510: SELECT aul.amount_to, aul.amount_from INTO l_amount_to, l_amount_from
3511: FROM ar_approval_user_limits aul
3512: WHERE aul.user_id = p_approver_id
3513: AND aul.reason_code = p_reason_code
3514: AND aul.currency_code = p_currency_code ;
3515: