DBA Data[Home] [Help]

APPS.GMPMRRP dependencies on FND_USER

Line 104: FROM fnd_user

100:
101: -- B2502197 Rajesh Patangya Splited queries into 2 parts
102: CURSOR Cur_Buyer_plnr(C_fBuyer_Plnr VARCHAR2 , C_tBuyer_Plnr VARCHAR2)IS
103: SELECT user_name
104: FROM fnd_user
105: WHERE user_name BETWEEN C_fBuyer_Plnr AND C_tBuyer_Plnr;
106:
107: CURSOR Cur_Buyer_plnr_id(C_Buyer_Plnr VARCHAR2)IS
108: SELECT user_id

Line 109: FROM fnd_user

105: WHERE user_name BETWEEN C_fBuyer_Plnr AND C_tBuyer_Plnr;
106:
107: CURSOR Cur_Buyer_plnr_id(C_Buyer_Plnr VARCHAR2)IS
108: SELECT user_id
109: FROM fnd_user
110: WHERE user_name = C_Buyer_Plnr ;
111:
112: BEGIN
113: retcode := 0;

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

123: G_fitem_no := V_fitem_no;
124: G_titem_no := V_titem_no;
125:
126: IF V_fBuyer_Plnr IS NULL THEN
127: select min(user_name) INTO X_fBuyer_Plnr from fnd_user;
128: ELSE
129: X_fBuyer_Plnr := V_fBuyer_plnr;
130: END IF;
131: IF V_tBuyer_plnr IS NULL THEN

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

128: ELSE
129: X_fBuyer_Plnr := V_fBuyer_plnr;
130: END IF;
131: IF V_tBuyer_plnr IS NULL THEN
132: select max(user_name) INTO X_tBuyer_Plnr from fnd_user;
133: ELSE
134: X_tBuyer_Plnr := V_tBuyer_plnr;
135: END IF;
136:

Line 256: ||' fnd_user f '

252: BEGIN
253: -- Building of the Where clause.
254: X_where := 'SELECT i.planning_class,i.item_id '
255: ||' FROM ps_oper_pcl c, ps_plng_cls p, ic_item_mst i, '
256: ||' fnd_user f '
257: ||' WHERE c.delete_mark=0 ' ;
258:
259: X_where := X_where
260: ||' AND f.user_id = :1 '