APPS.ASG_PUB_SEQUENCE_PKG dependencies on ASG_USER

Line 34: from ASG_USER

30:
31: CURSOR C_CLIENT_NUMBER(v_clientid varchar2)
32: IS
33: Select client_number
34: from ASG_USER
35: where upper(user_name) = upper(v_clientid);
36:
37: v_client_number number;
38: BEGIN

Line 158: FROM ASG_USER

154: Prev_Num INTEGER;
155: Ret_Flag BOOLEAN := FALSE;
156: CURSOR client_num_cur(StartNum INTEGER) IS
157: SELECT client_number
158: FROM ASG_USER
159: WHERE client_number > StartNum
160: ORDER BY client_number;
161: CURSOR start_num_cur(StartNum INTEGER) IS
162: SELECT client_number

Line 163: FROM ASG_USER

159: WHERE client_number > StartNum
160: ORDER BY client_number;
161: CURSOR start_num_cur(StartNum INTEGER) IS
162: SELECT client_number
163: FROM ASG_USER
164: WHERE client_number = StartNum;
165: CURSOR max_client_num_cur IS
166: SELECT MAX(Client_Number)
167: FROM ASG_USER;

Line 167: FROM ASG_USER;

163: FROM ASG_USER
164: WHERE client_number = StartNum;
165: CURSOR max_client_num_cur IS
166: SELECT MAX(Client_Number)
167: FROM ASG_USER;
168: BEGIN
169:
170: if (StartNum >= MaxClientNum) then
171: return(0);