APPS.ARP_CMREQ_WF dependencies on AR_APPROVAL_USER_LIMITS

Line 1335: FROM ar_approval_user_limits aul

1331: FROM fnd_user
1332: WHERE user_name = l_approver_name;
1333:
1334: SELECT primary_flag INTO l_primary_flag
1335: FROM ar_approval_user_limits aul
1336: WHERE reason_code = l_reason_code
1337: AND currency_code = l_currency_code
1338: AND user_id = l_employee_id;
1339:

Line 1790: from ar_approval_user_limits aul

1786: l_currency_code varchar2(30);
1787:
1788: cursor c1 is
1789: select count(*)
1790: from ar_approval_user_limits aul
1791: where aul.reason_code = l_reason_code
1792: and aul.currency_code = l_currency_code
1793: and aul.primary_flag = p_primary_flag
1794: and user_id = p_employee_id

Line 1837: from ar_approval_user_limits aul

1833:
1834:
1835: cursor c1 is
1836: select aul.user_id
1837: from ar_approval_user_limits aul
1838: where aul.reason_code = p_reason_code
1839: and aul.currency_code = p_currency_code
1840: and aul.primary_flag = 'Y'
1841: order by - aul.amount_from;

Line 1892: from ar_approval_user_limits aul

1888: p_approver_employee_id OUT NOCOPY NUMBER) IS
1889:
1890: cursor c1 is
1891: select aul.user_id
1892: from ar_approval_user_limits aul
1893: where aul.reason_code = p_reason_code
1894: and aul.currency_code = p_currency_code
1895: and aul.primary_flag = 'Y'
1896: order by - aul.amount_from;

Line 2864: from ar_approval_user_limits aul

2860: ---------------------------------------------------------------------------
2861:
2862: select aul.amount_to, aul.amount_from
2863: into l_amount_to, l_amount_from
2864: from ar_approval_user_limits aul
2865: where aul.user_id = p_approver_id
2866: and aul.reason_code = p_reason_code
2867: and aul.currency_code = p_currency_code ;
2868: