APPS.ARP_CMREQ_WF dependencies on AR_APPROVAL_USER_LIMITS

Line 1294: FROM ar_approval_user_limits aul

1290: FROM fnd_user
1291: WHERE user_name = l_approver_name;
1292:
1293: SELECT primary_flag INTO l_primary_flag
1294: FROM ar_approval_user_limits aul
1295: WHERE reason_code = l_reason_code
1296: AND currency_code = l_currency_code
1297: AND user_id = l_employee_id;
1298:

Line 1749: from ar_approval_user_limits aul

1745: l_currency_code varchar2(30);
1746:
1747: cursor c1 is
1748: select count(*)
1749: from ar_approval_user_limits aul
1750: where aul.reason_code = l_reason_code
1751: and aul.currency_code = l_currency_code
1752: and aul.primary_flag = p_primary_flag
1753: and user_id = p_employee_id

Line 1796: from ar_approval_user_limits aul

1792:
1793:
1794: cursor c1 is
1795: select aul.user_id
1796: from ar_approval_user_limits aul
1797: where aul.reason_code = p_reason_code
1798: and aul.currency_code = p_currency_code
1799: and aul.primary_flag = 'Y'
1800: order by - aul.amount_from;

Line 1851: from ar_approval_user_limits aul

1847: p_approver_employee_id OUT NOCOPY NUMBER) IS
1848:
1849: cursor c1 is
1850: select aul.user_id
1851: from ar_approval_user_limits aul
1852: where aul.reason_code = p_reason_code
1853: and aul.currency_code = p_currency_code
1854: and aul.primary_flag = 'Y'
1855: order by - aul.amount_from;

Line 2823: from ar_approval_user_limits aul

2819: ---------------------------------------------------------------------------
2820:
2821: select aul.amount_to, aul.amount_from
2822: into l_amount_to, l_amount_from
2823: from ar_approval_user_limits aul
2824: where aul.user_id = p_approver_id
2825: and aul.reason_code = p_reason_code
2826: and aul.currency_code = p_currency_code ;
2827: