DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_PKG_S1 dependencies on PO_LINES_ALL

Line 125: l_purchase_basis po_lines_all.purchase_basis%TYPE;

121: WHERE rowid = X_Rowid
122: FOR UPDATE of Line_Location_Id NOWAIT;
123: Recinfo C%ROWTYPE;
124:
125: l_purchase_basis po_lines_all.purchase_basis%TYPE;
126:
127: BEGIN
128: OPEN C;
129: FETCH C INTO Recinfo;

Line 144: FROM po_lines_all

140: -- SQL Why : To use in the lock row to not compare amounts for temp
141: -- labor lines
142: SELECT purchase_basis
143: INTO l_purchase_basis
144: FROM po_lines_all
145: WHERE po_line_id = Recinfo.po_line_id;
146: Exception
147: when others then
148: APP_EXCEPTION.RAISE_EXCEPTION;