APPS.AR_ADJVALIDATE_PUB dependencies on AR_APPROVAL_USER_LIMITS

Line 1148: l_user_id ar_approval_user_limits.user_id%type;

1144: p_approved_flag IN OUT NOCOPY varchar2,
1145: p_return_status IN OUT NOCOPY varchar2
1146: ) IS
1147:
1148: l_user_id ar_approval_user_limits.user_id%type;
1149: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1150: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1151:
1152: BEGIN

Line 1149: l_approval_amount_to ar_approval_user_limits.amount_to%type;

1145: p_return_status IN OUT NOCOPY varchar2
1146: ) IS
1147:
1148: l_user_id ar_approval_user_limits.user_id%type;
1149: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1150: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1151:
1152: BEGIN
1153:

Line 1150: l_approval_amount_from ar_approval_user_limits.amount_from%type;

1146: ) IS
1147:
1148: l_user_id ar_approval_user_limits.user_id%type;
1149: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1150: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1151:
1152: BEGIN
1153:
1154: IF PG_DEBUG in ('Y', 'C') THEN

Line 1177: FROM ar_approval_user_limits

1173: SELECT amount_to,
1174: amount_from
1175: INTO l_approval_amount_to,
1176: l_approval_amount_from
1177: FROM ar_approval_user_limits
1178: WHERE user_id = l_user_id
1179: AND currency_code = p_inv_curr_code;
1180:
1181: EXCEPTION

Line 1699: l_approval_amount_to ar_approval_user_limits.amount_to%type;

1695: ) IS
1696:
1697: l_index number;
1698: l_user_id BINARY_INTEGER;
1699: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1700: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1701: l_approved_flag VARCHAR2(1);
1702: l_return_status VARCHAR2(1);
1703: BEGIN

Line 1700: l_approval_amount_from ar_approval_user_limits.amount_from%type;

1696:
1697: l_index number;
1698: l_user_id BINARY_INTEGER;
1699: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1700: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1701: l_approved_flag VARCHAR2(1);
1702: l_return_status VARCHAR2(1);
1703: BEGIN
1704: