eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_MATCH_TAX_PKG dependencies on RA_TERMS_LINES

Line 1346: --Get the relative_amount from ra_terms_lines

1342: FROM ra_terms
1343: WHERE term_id = cp_term_id;
1344:
1345:
1346: --Get the relative_amount from ra_terms_lines
1347: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1349: IS
1350: SELECT relative_amount

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

1343: WHERE term_id = cp_term_id;
1344:
1345:
1346: --Get the relative_amount from ra_terms_lines
1347: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1349: IS
1350: SELECT relative_amount
1351: FROM ra_terms_lines

Line 1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)

1344:
1345:
1346: --Get the relative_amount from ra_terms_lines
1347: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1349: IS
1350: SELECT relative_amount
1351: FROM ra_terms_lines
1352: WHERE term_id = cp_term_id

Line 1351: FROM ra_terms_lines

1347: CURSOR cur_term_lines(cp_term_id ra_terms_lines.term_id%TYPE,
1348: cp_sequence_num ra_terms_lines.sequence_num%TYPE)
1349: IS
1350: SELECT relative_amount
1351: FROM ra_terms_lines
1352: WHERE term_id = cp_term_id
1353: AND sequence_num = cp_sequence_num;
1354:
1355:

Line 1941: --Get the relative_amount from ra_terms_lines

1937: fnd_file.put_line(FND_FILE.LOG, 'In rec_payment LOOP');
1938: END IF;
1939:
1940:
1941: --Get the relative_amount from ra_terms_lines
1942: OPEN cur_term_lines(rec_payment.term_id,
1943: rec_payment.terms_sequence_number);
1944: FETCH cur_term_lines INTO ln_relative_amt;
1945: CLOSE cur_term_lines;

Line 2192: --Get the relative_amount from ra_terms_lines

2188: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);
2189: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);
2190: END IF;
2191:
2192: --Get the relative_amount from ra_terms_lines
2193: OPEN cur_term_lines(rec_payment.term_id,
2194: rec_payment.terms_sequence_number);
2195: FETCH cur_term_lines INTO ln_relative_amt;
2196: CLOSE cur_term_lines;