DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on OE_AGREEMENTS

Line 255: FROM oe_agreements_vl

251: l_name varchar2(240);
252: --
253: CURSOR l_agreement_cursor(name_in varchar2) is
254: SELECT agreement_id
255: FROM oe_agreements_vl
256: WHERE name = name_in;
257: --
258: BEGIN
259:

Line 261: from oe_agreements_vl

257: --
258: BEGIN
259:
260: select name into l_name
261: from oe_agreements_vl
262: WHERE agreement_id = p_agreement_id
263: AND ROWNUM=1;
264:
265: /*

Line 268: FROM oe_agreements_vl

264:
265: /*
266: OPEN l_agreement_cursor FOR
267: SELECT agreement_id
268: FROM oe_agreements_vl
269: WHERE name = l_name;
270: */
271:
272: OPEN l_agreement_cursor(l_name);

Line 556: FROM oe_agreements

552: G_Agreement_Info.agreement_type_code := NULL; -- bug#3276930
553:
554: SELECT agreement_type_code
555: INTO G_Agreement_Info.agreement_type_code
556: FROM oe_agreements
557: WHERE agreement_id = p_agreement_id;
558:
559: RETURN G_Agreement_Info.agreement_type_code;
560: