DBA Data[Home] [Help]

APPS.AR_AME_CMWF_API dependencies on AR_APPROVAL_USER_LIMITS

Line 620: FROM ar_approval_user_limits aul

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

Line 3470: FROM ar_approval_user_limits aul

3466: END IF;
3467: ----------------------------------------------------------
3468:
3469: SELECT aul.amount_to, aul.amount_from INTO l_amount_to, l_amount_from
3470: FROM ar_approval_user_limits aul
3471: WHERE aul.user_id = p_approver_id
3472: AND aul.reason_code = p_reason_code
3473: AND aul.currency_code = p_currency_code ;
3474: