APPS.ARP_PROCESS_ADJUSTMENT dependencies on RA_CUSTOMER_TRX_LINES

Line 440: ra_customer_trx_lines ctl

436: INTO l_term_ratio,
437: l_line_original
438: FROM ra_terms_lines tl,
439: ra_terms t,
440: ra_customer_trx_lines ctl
441: WHERE p_ps_rec.term_id = t.term_id
442: AND t.term_id = tl.term_id
443: AND p_ps_rec.terms_sequence_number = tl.sequence_num
444: AND ctl.customer_trx_line_id =

Line 449: FROM ra_customer_trx_lines ctl

445: p_adj_rec.customer_trx_line_id;
446: ELSE /* 1909312 Code Added begins */
447: SELECT ctl.extended_amount
448: INTO l_line_original
449: FROM ra_customer_trx_lines ctl
450: WHERE ctl.customer_trx_line_id =
451: p_adj_rec.customer_trx_line_id;
452: l_term_ratio := 1;
453: END IF; /* 1909312 Code Added Ends */

Line 471: FROM ra_customer_trx_lines ctl

467: ),
468: p_ps_rec.invoice_currency_code
469: )
470: INTO l_line_credited
471: FROM ra_customer_trx_lines ctl
472: WHERE ctl.previous_customer_trx_line_id =
473: p_adj_rec.customer_trx_line_id;
474:
475: /*

Line 3256: | ra_customer_Trx_lines for Line Level |

3252: | calculate prorated amounts for activity|
3253: | tax code |
3254: | 17-AUG-05 Debbie Jancis Added customer_Trx_line_id for LLCA |
3255: | and selected the balances from |
3256: | ra_customer_Trx_lines for Line Level |
3257: +===========================================================================*/
3258:
3259: PROCEDURE cal_prorated_amounts( p_adj_amount IN number,
3260: p_payment_schedule_id IN number,

Line 3362: ra_customer_trx_lines lines

3358: INTO l_line_remaining,
3359: l_tax_remaining,
3360: l_invoice_currency_code
3361: FROM ra_customer_trx ct,
3362: ra_customer_trx_lines lines
3363: WHERE (lines.customer_Trx_line_id = p_cust_trx_line_id or
3364: lines.link_to_cust_trx_line_id = p_cust_trx_line_id)
3365: AND ct.customer_Trx_id = lines.customer_trx_id;
3366: END IF;