APPS.IBE_QUOTE_SAVE_PVT dependencies on OE_AGREEMENTS_B

Line 640: FROM OE_Agreements_B

636: -- if contract_id is not null, get its associated price list id from DB
637: ELSE
638: SELECT price_list_id
639: INTO x_qte_header_rec.price_list_id
640: FROM OE_Agreements_B
641: WHERE agreement_id = x_qte_header_rec.contract_id;
642:
643: l_agmt_associated := FND_API.G_TRUE;
644: END IF;

Line 716: FROM OE_Agreements_B

712: x_qte_header_rec.contract_id := l_contract_id;
713:
714: SELECT price_list_id
715: INTO x_qte_header_rec.price_list_id
716: FROM OE_Agreements_B
717: WHERE agreement_id = l_contract_id;
718: END IF;
719: --DBMS_OUTPUT.PUT_line('BEFORE header agreements ');
720: header_agreements(

Line 3234: from oe_agreements_b

3230: ) is
3231: /*This cursor selects price_list_id and term_id(payment_term_id as in aso_payments) */
3232: cursor c_term_pricelist(p_agreement_id number) is
3233: select price_list_id, term_id
3234: from oe_agreements_b
3235: where agreement_id = p_agreement_id;
3236: /*This cursor selects payment_id from aso_payments based on the qte_header_id and quote_line_id*/
3237: cursor c_payment_id(p_quote_header_id number, p_quote_line_id number) is
3238: select payment_id

Line 4357: from oe_agreements_b

4353: /*This cursor retrieves payment_term_id and price_list_id for a given agreement id
4354: this modification added to support bundles in iStore */
4355: cursor c_term_pricelist(p_agreement_id number) is
4356: select term_id, price_list_id
4357: from oe_agreements_b
4358: where agreement_id = p_agreement_id;
4359:
4360: Cursor c_quote_sts_id(p_status_code varchar2) is
4361: select quote_status_id