DBA Data[Home] [Help]

APPS.OE_PREPAYMENT_PVT dependencies on RA_TERMS

Line 3600: from ra_terms rat, oe_order_headers_all oeh

3596: and line_id is null;
3597:
3598: /*
3599: and exists ( select null
3600: from ra_terms rat, oe_order_headers_all oeh
3601: where oeh.header_id = p_header_id
3602: and oeh.payment_term_id = rat.term_id
3603: and rat.prepayment_flag = 'Y' );
3604: */

Line 4945: FROM ra_terms t,

4941: ) IS
4942:
4943: CURSOR due_now_cur(p_term_id IN NUMBER) IS
4944: SELECT first_installment_code , relative_amount/base_amount
4945: FROM ra_terms t,
4946: ra_terms_lines tl
4947: WHERE t.term_id = tl.term_id
4948: AND t.term_id = p_term_id
4949: AND sequence_num = 1;

Line 4946: ra_terms_lines tl

4942:
4943: CURSOR due_now_cur(p_term_id IN NUMBER) IS
4944: SELECT first_installment_code , relative_amount/base_amount
4945: FROM ra_terms t,
4946: ra_terms_lines tl
4947: WHERE t.term_id = tl.term_id
4948: AND t.term_id = p_term_id
4949: AND sequence_num = 1;
4950: