APPS.IBE_QUOTE_SAVE_PVT dependencies on OE_AGREEMENTS_B

Line 659: FROM OE_Agreements_B

655: -- if contract_id is not null, get its associated price list id from DB
656: ELSE
657: SELECT price_list_id
658: INTO x_qte_header_rec.price_list_id
659: FROM OE_Agreements_B
660: WHERE agreement_id = x_qte_header_rec.contract_id;
661:
662: l_agmt_associated := FND_API.G_TRUE;
663: END IF;

Line 735: FROM OE_Agreements_B

731: x_qte_header_rec.contract_id := l_contract_id;
732:
733: SELECT price_list_id
734: INTO x_qte_header_rec.price_list_id
735: FROM OE_Agreements_B
736: WHERE agreement_id = l_contract_id;
737: END IF;
738: --DBMS_OUTPUT.PUT_line('BEFORE header agreements ');
739: header_agreements(

Line 3253: from oe_agreements_b

3249: ) is
3250: /*This cursor selects price_list_id and term_id(payment_term_id as in aso_payments) */
3251: cursor c_term_pricelist(p_agreement_id number) is
3252: select price_list_id, term_id
3253: from oe_agreements_b
3254: where agreement_id = p_agreement_id;
3255: /*This cursor selects payment_id from aso_payments based on the qte_header_id and quote_line_id*/
3256: cursor c_payment_id(p_quote_header_id number, p_quote_line_id number) is
3257: select payment_id

Line 4388: from oe_agreements_b

4384: /*This cursor retrieves payment_term_id and price_list_id for a given agreement id
4385: this modification added to support bundles in iStore */
4386: cursor c_term_pricelist(p_agreement_id number) is
4387: select term_id, price_list_id
4388: from oe_agreements_b
4389: where agreement_id = p_agreement_id;
4390:
4391: Cursor c_quote_sts_id(p_status_code varchar2) is
4392: select quote_status_id