APPS.JAI_AR_MATCH_TAX_PKG dependencies on RA_TERMS_LINES

Line 1968: --Get the relative_amount from ra_terms_lines

1964: FROM ra_terms
1965: WHERE term_id = cp_term_id;
1966:
1967:
1968: --Get the relative_amount from ra_terms_lines
1969: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1970: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1971: IS
1972: SELECT relative_amount

Line 1969: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,

1965: WHERE term_id = cp_term_id;
1966:
1967:
1968: --Get the relative_amount from ra_terms_lines
1969: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1970: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1971: IS
1972: SELECT relative_amount
1973: FROM ra_terms_lines

Line 1970: cp_sequence_num ra_terms_lines.sequence_num%TYPE)

1966:
1967:
1968: --Get the relative_amount from ra_terms_lines
1969: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1970: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1971: IS
1972: SELECT relative_amount
1973: FROM ra_terms_lines
1974: WHERE term_id = cp_term_id

Line 1973: FROM ra_terms_lines

1969: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1970: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1971: IS
1972: SELECT relative_amount
1973: FROM ra_terms_lines
1974: WHERE term_id = cp_term_id
1975: AND sequence_num = cp_sequence_num;
1976:
1977:

Line 2749: --Get the relative_amount from ra_terms_lines

2745: fnd_file.put_line(FND_FILE.LOG, 'In rec_payment LOOP');
2746: END IF;
2747:
2748:
2749: --Get the relative_amount from ra_terms_lines
2750: OPEN cur_term_lines(rec_payment.term_id,
2751: rec_payment.terms_sequence_number);
2752: FETCH cur_term_lines INTO ln_relative_amt;
2753: CLOSE cur_term_lines;

Line 3059: --Get the relative_amount from ra_terms_lines

3055: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);
3056: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);
3057: END IF;
3058:
3059: --Get the relative_amount from ra_terms_lines
3060: OPEN cur_term_lines(rec_payment.term_id,
3061: rec_payment.terms_sequence_number);
3062: FETCH cur_term_lines INTO ln_relative_amt;
3063: CLOSE cur_term_lines;