APPS.AR_ADJVALIDATE_PVT dependencies on AR_APPROVAL_USER_LIMITS

Line 1121: l_user_id ar_approval_user_limits.user_id%type;

1117: p_approved_flag IN OUT NOCOPY varchar2,
1118: p_return_status IN OUT NOCOPY varchar2
1119: ) IS
1120:
1121: l_user_id ar_approval_user_limits.user_id%type;
1122: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1123: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1124:
1125: BEGIN

Line 1122: l_approval_amount_to ar_approval_user_limits.amount_to%type;

1118: p_return_status IN OUT NOCOPY varchar2
1119: ) IS
1120:
1121: l_user_id ar_approval_user_limits.user_id%type;
1122: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1123: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1124:
1125: BEGIN
1126:

Line 1123: l_approval_amount_from ar_approval_user_limits.amount_from%type;

1119: ) IS
1120:
1121: l_user_id ar_approval_user_limits.user_id%type;
1122: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1123: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1124:
1125: BEGIN
1126:
1127: IF PG_DEBUG in ('Y', 'C') THEN

Line 1150: FROM ar_approval_user_limits

1146: SELECT amount_to,
1147: amount_from
1148: INTO l_approval_amount_to,
1149: l_approval_amount_from
1150: FROM ar_approval_user_limits
1151: WHERE user_id = l_user_id
1152: AND currency_code = p_inv_curr_code
1153: AND document_type = 'ADJ';
1154:

Line 1931: l_approval_amount_to ar_approval_user_limits.amount_to%type;

1927: ) IS
1928:
1929: l_index number;
1930: l_user_id BINARY_INTEGER;
1931: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1932: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1933: l_approved_flag VARCHAR2(1);
1934: l_return_status VARCHAR2(1);
1935:

Line 1932: l_approval_amount_from ar_approval_user_limits.amount_from%type;

1928:
1929: l_index number;
1930: l_user_id BINARY_INTEGER;
1931: l_approval_amount_to ar_approval_user_limits.amount_to%type;
1932: l_approval_amount_from ar_approval_user_limits.amount_from%type;
1933: l_approved_flag VARCHAR2(1);
1934: l_return_status VARCHAR2(1);
1935:
1936: BEGIN