DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on OE_AGREEMENTS_VL

Line 263: FROM oe_agreements_vl

259: l_name varchar2(240);
260: --
261: CURSOR l_agreement_cursor(name_in varchar2) is
262: SELECT agreement_id
263: FROM oe_agreements_vl
264: WHERE name = name_in;
265: --
266: BEGIN
267:

Line 269: from oe_agreements_vl

265: --
266: BEGIN
267:
268: select name into l_name
269: from oe_agreements_vl
270: WHERE agreement_id = p_agreement_id
271: AND ROWNUM=1;
272:
273: /*

Line 276: FROM oe_agreements_vl

272:
273: /*
274: OPEN l_agreement_cursor FOR
275: SELECT agreement_id
276: FROM oe_agreements_vl
277: WHERE name = l_name;
278: */
279:
280: OPEN l_agreement_cursor(l_name);