DBA Data[Home] [Help]

APPS.OE_PREPAYMENT_PVT dependencies on RA_TERMS

Line 3466: from ra_terms rat, oe_order_headers_all oeh

3462: and line_id is null;
3463:
3464: /*
3465: and exists ( select null
3466: from ra_terms rat, oe_order_headers_all oeh
3467: where oeh.header_id = p_header_id
3468: and oeh.payment_term_id = rat.term_id
3469: and rat.prepayment_flag = 'Y' );
3470: */

Line 4811: FROM ra_terms t,

4807: ) IS
4808:
4809: CURSOR due_now_cur(p_term_id IN NUMBER) IS
4810: SELECT first_installment_code , relative_amount/base_amount
4811: FROM ra_terms t,
4812: ra_terms_lines tl
4813: WHERE t.term_id = tl.term_id
4814: AND t.term_id = p_term_id
4815: AND sequence_num = 1;

Line 4812: ra_terms_lines tl

4808:
4809: CURSOR due_now_cur(p_term_id IN NUMBER) IS
4810: SELECT first_installment_code , relative_amount/base_amount
4811: FROM ra_terms t,
4812: ra_terms_lines tl
4813: WHERE t.term_id = tl.term_id
4814: AND t.term_id = p_term_id
4815: AND sequence_num = 1;
4816: