APPS.GMPMRACT dependencies on FND_USER

Line 129: FROM fnd_user

125: X_tBuyer_Plnr VARCHAR2(100);
126:
127: CURSOR Cur_Buyer_plnr(C_fBuyer_Plnr VARCHAR2 , C_tBuyer_Plnr VARCHAR2)IS
128: SELECT user_name
129: FROM fnd_user
130: WHERE (C_fBuyer_Plnr is NULL OR user_name >= C_fBuyer_Plnr)
131: AND (C_tBuyer_Plnr is NULL OR user_name <= C_tBuyer_Plnr);
132:
133: CURSOR Cur_Buyer_plnr_id(C_Buyer_Plnr VARCHAR2)IS

Line 135: FROM fnd_user

131: AND (C_tBuyer_Plnr is NULL OR user_name <= C_tBuyer_Plnr);
132:
133: CURSOR Cur_Buyer_plnr_id(C_Buyer_Plnr VARCHAR2)IS
134: SELECT user_id
135: FROM fnd_user
136: WHERE user_name = C_Buyer_Plnr ;
137:
138: BEGIN
139: retcode := 0;

Line 154: select min(user_name) INTO X_fBuyer_Plnr from fnd_user;

150: G_titem_no := V_titem_no;
151: G_critical_indicator := V_critical_indicator;
152:
153: IF V_fBuyer_plnr IS NULL THEN
154: select min(user_name) INTO X_fBuyer_Plnr from fnd_user;
155: ELSE
156: X_fBuyer_Plnr := V_fBuyer_plnr;
157: END IF;
158:

Line 160: select max(user_name) INTO X_tBuyer_Plnr from fnd_user;

156: X_fBuyer_Plnr := V_fBuyer_plnr;
157: END IF;
158:
159: IF V_tBuyer_plnr IS NULL THEN
160: select max(user_name) INTO X_tBuyer_Plnr from fnd_user;
161: ELSE
162: X_tBuyer_Plnr := V_tBuyer_plnr;
163: END IF;
164:

Line 297: ||' fnd_user f '

293: BEGIN
294: -- Building of the Where clause.
295: X_where := 'SELECT i.planning_class,i.item_id '
296: ||' FROM ps_oper_pcl c, ps_plng_cls p, ic_item_mst i, '
297: ||' fnd_user f '
298: ||' WHERE c.delete_mark=0 ' ;
299:
300: X_where := X_where
301: ||' AND f.user_id = :1 '