APPS.ARP_PROCESS_ADJUSTMENT dependencies on RA_CUSTOMER_TRX

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 1756: from ra_customer_trx ct, ra_cust_trx_types ctt

1752: BEGIN
1753:
1754: Select decode (nvl(ctt.post_to_gl,'N'),'Y', 'Y', nvl(ctt.adj_post_to_gl,'N'))
1755: into l_adj_post_to_gl
1756: from ra_customer_trx ct, ra_cust_trx_types ctt
1757: where ct.customer_trx_id = l_adj_rec.customer_trx_id
1758: and ct.cust_trx_type_id = ctt.cust_trx_type_id ;
1759:
1760: IF PG_DEBUG in ('Y', 'C') THEN

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 3305: FROM ra_customer_Trx trx,

3301:
3302: IF (arp_legal_entity_util.Is_LE_Subscriber) THEN
3303: SELECT trx.legal_entity_id
3304: INTO l_le_id
3305: FROM ra_customer_Trx trx,
3306: ar_payment_schedules ps
3307: where ps.payment_schedule_id = p_payment_schedule_id
3308: and ps.customer_trx_id = trx.customer_trx_id;
3309:

Line 3361: FROM ra_customer_trx ct,

3357: max(ct.invoice_currency_code) -- curr code
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;

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;