APPS.AR_RECEIPT_LIB_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 2892: from ra_customer_trx_lines line,

2888: into
2889: l_line_number,
2890: l_line_amount_remaining,
2891: l_line_tax_remaining
2892: from ra_customer_trx_lines line,
2893: (select link_to_cust_trx_line_id,
2894: line_type,
2895: sum(nvl(amount_due_original,0)) amount_due_original,
2896: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 2897: from ra_customer_trx_lines

2893: (select link_to_cust_trx_line_id,
2894: line_type,
2895: sum(nvl(amount_due_original,0)) amount_due_original,
2896: sum(nvl(amount_due_remaining,0)) amount_due_remaining
2897: from ra_customer_trx_lines
2898: where customer_trx_id = sp_lines_row.customer_trx_id -- Bug 7241703 Added condition
2899: and nvl(line_type,'TAX') = 'TAX'
2900: group by link_to_cust_trx_line_id,line_type
2901: ) tax

Line 3535: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,

3531:
3532: FUNCTION Get_trx_Line_amount(
3533: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3534: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3535: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
3536: p_return_status OUT NOCOPY VARCHAR2
3537: ) RETURN NUMBER IS
3538:
3539: l_trx_line_amount NUMBER;

Line 3548: FROM ra_customer_trx_lines ctl ,

3544:
3545: SELECT ctl.extended_amount *
3546: nvl(tl.relative_amount,1)/ nvl(t.base_amount,1)
3547: INTO l_trx_line_amount
3548: FROM ra_customer_trx_lines ctl ,
3549: ra_terms t ,
3550: ra_terms_lines tl ,
3551: ar_payment_schedules ps
3552: WHERE ps.payment_schedule_id = p_payment_schedule_id and

Line 4470: from ra_customer_trx_lines line

4466: p_return_status := FND_API.G_RET_STS_SUCCESS;
4467:
4468: select count(1)
4469: into l_count
4470: from ra_customer_trx_lines line
4471: where line.customer_Trx_id = p_customer_trx_id
4472: and line.line_type = 'LINE'
4473: and line.source_data_key4 = p_group_id
4474: and rownum = 1;

Line 4526: FROM ra_customer_trx_lines

4522: IF p_line_number IS NOT NULL THEN
4523: BEGIN
4524: SELECT customer_trx_line_id
4525: INTO p_customer_trx_line_id
4526: FROM ra_customer_trx_lines
4527: WHERE customer_trx_id = p_customer_trx_id
4528: AND line_number = p_line_number
4529: AND line_type = 'LINE';
4530: EXCEPTION

Line 4545: FROM ra_customer_trx_lines

4541: IF p_customer_trx_line_id IS NOT NULL THEN
4542: BEGIN
4543: SELECT customer_trx_id
4544: INTO p_customer_trx_id
4545: FROM ra_customer_trx_lines
4546: WHERE customer_trx_line_id = p_customer_trx_line_id
4547: AND line_type = 'LINE';
4548: EXCEPTION
4549: WHEN no_data_found THEN

Line 4575: FROM ra_customer_trx_lines

4571: Then
4572: BEGIN
4573: SELECT customer_trx_line_id
4574: INTO l_cust_trx_line_id
4575: FROM ra_customer_trx_lines
4576: WHERE customer_trx_id = p_customer_trx_id
4577: AND line_number = i.line_number
4578: AND line_type = 'LINE';
4579:

Line 4600: FROM ra_customer_trx_lines

4596: Else
4597: BEGIN
4598: SELECT customer_trx_line_id
4599: INTO l_cust_trx_line_id
4600: FROM ra_customer_trx_lines
4601: WHERE customer_trx_id = p_customer_trx_id
4602: AND customer_trx_line_id = i.customer_trx_line_id
4603: AND line_type = 'LINE';
4604: EXCEPTION