APPS.JAI_AR_MATCH_TAX_PKG dependencies on RA_TERMS

Line 1959: --Get the first_installment_code and base_amount from ra_terms

1955: WHERE customer_trx_id = cp_customer_trx_id
1956: FOR UPDATE NOWAIT;
1957:
1958:
1959: --Get the first_installment_code and base_amount from ra_terms
1960: CURSOR cur_term_details(cp_term_id ra_terms.term_id%TYPE)
1961: IS
1962: SELECT first_installment_code,
1963: DECODE(base_amount, 0, 1, base_amount) base_amount

Line 1960: CURSOR cur_term_details(cp_term_id ra_terms.term_id%TYPE)

1956: FOR UPDATE NOWAIT;
1957:
1958:
1959: --Get the first_installment_code and base_amount from ra_terms
1960: CURSOR cur_term_details(cp_term_id ra_terms.term_id%TYPE)
1961: IS
1962: SELECT first_installment_code,
1963: DECODE(base_amount, 0, 1, base_amount) base_amount
1964: FROM ra_terms

Line 1964: FROM ra_terms

1960: CURSOR cur_term_details(cp_term_id ra_terms.term_id%TYPE)
1961: IS
1962: SELECT first_installment_code,
1963: DECODE(base_amount, 0, 1, base_amount) base_amount
1964: FROM ra_terms
1965: WHERE term_id = cp_term_id;
1966:
1967:
1968: --Get the relative_amount from 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 2714: --Get the first_installment_code and base_amount from ra_terms

2710: OPEN cur_min_payment_schedule(ln_previous_customer_trx_id);
2711: FETCH cur_min_payment_schedule INTO rec_inv_payment_schedule;
2712: CLOSE cur_min_payment_schedule;
2713:
2714: --Get the first_installment_code and base_amount from ra_terms
2715: OPEN cur_term_details(rec_inv_payment_schedule.term_id);
2716: FETCH cur_term_details INTO rec_term_details;
2717: CLOSE cur_term_details;
2718:

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 3045: --Get the first_installment_code and base_amount from ra_terms

3041: IF p_debug = 'Y' THEN
3042: fnd_file.put_line(FND_FILE.LOG, 'In else of previous_customer_trx_id');
3043: END IF;
3044:
3045: --Get the first_installment_code and base_amount from ra_terms
3046: OPEN cur_term_details(rec_min_payment_schedule.term_id);
3047: FETCH cur_term_details INTO rec_term_details;
3048: CLOSE cur_term_details;
3049:

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;