APPS.AR_RECEIPT_LIB_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 2789: from ra_customer_trx_lines line,

2785: into
2786: l_line_number,
2787: l_line_amount_remaining,
2788: l_line_tax_remaining
2789: from ra_customer_trx_lines line,
2790: (select link_to_cust_trx_line_id,
2791: line_type,
2792: sum(nvl(amount_due_original,0)) amount_due_original,
2793: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 2794: from ra_customer_trx_lines

2790: (select link_to_cust_trx_line_id,
2791: line_type,
2792: sum(nvl(amount_due_original,0)) amount_due_original,
2793: sum(nvl(amount_due_remaining,0)) amount_due_remaining
2794: from ra_customer_trx_lines
2795: where customer_trx_id = sp_lines_row.customer_trx_id -- Bug 7241703 Added condition
2796: and nvl(line_type,'TAX') = 'TAX'
2797: group by link_to_cust_trx_line_id,line_type
2798: ) tax

Line 3353: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,

3349:
3350: FUNCTION Get_trx_Line_amount(
3351: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3352: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3353: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
3354: p_return_status OUT NOCOPY VARCHAR2
3355: ) RETURN NUMBER IS
3356:
3357: l_trx_line_amount NUMBER;

Line 3366: FROM ra_customer_trx_lines ctl ,

3362:
3363: SELECT ctl.extended_amount *
3364: nvl(tl.relative_amount,1)/ nvl(t.base_amount,1)
3365: INTO l_trx_line_amount
3366: FROM ra_customer_trx_lines ctl ,
3367: ra_terms t ,
3368: ra_terms_lines tl ,
3369: ar_payment_schedules ps
3370: WHERE ps.payment_schedule_id = p_payment_schedule_id and

Line 4241: from ra_customer_trx_lines line

4237: p_return_status := FND_API.G_RET_STS_SUCCESS;
4238:
4239: select count(1)
4240: into l_count
4241: from ra_customer_trx_lines line
4242: where line.customer_Trx_id = p_customer_trx_id
4243: and line.line_type = 'LINE'
4244: and line.source_data_key4 = p_group_id
4245: and rownum = 1;

Line 4297: FROM ra_customer_trx_lines

4293: IF p_line_number IS NOT NULL THEN
4294: BEGIN
4295: SELECT customer_trx_line_id
4296: INTO p_customer_trx_line_id
4297: FROM ra_customer_trx_lines
4298: WHERE customer_trx_id = p_customer_trx_id
4299: AND line_number = p_line_number
4300: AND line_type = 'LINE';
4301: EXCEPTION

Line 4316: FROM ra_customer_trx_lines

4312: IF p_customer_trx_line_id IS NOT NULL THEN
4313: BEGIN
4314: SELECT customer_trx_id
4315: INTO p_customer_trx_id
4316: FROM ra_customer_trx_lines
4317: WHERE customer_trx_line_id = p_customer_trx_line_id
4318: AND line_type = 'LINE';
4319: EXCEPTION
4320: WHEN no_data_found THEN

Line 4346: FROM ra_customer_trx_lines

4342: Then
4343: BEGIN
4344: SELECT customer_trx_line_id
4345: INTO l_cust_trx_line_id
4346: FROM ra_customer_trx_lines
4347: WHERE customer_trx_id = p_customer_trx_id
4348: AND line_number = i.line_number
4349: AND line_type = 'LINE';
4350:

Line 4371: FROM ra_customer_trx_lines

4367: Else
4368: BEGIN
4369: SELECT customer_trx_line_id
4370: INTO l_cust_trx_line_id
4371: FROM ra_customer_trx_lines
4372: WHERE customer_trx_id = p_customer_trx_id
4373: AND customer_trx_line_id = i.customer_trx_line_id
4374: AND line_type = 'LINE';
4375: EXCEPTION