APPS.FUN_NET_ARAP_PKG dependencies on RA_TERMS_LINES_DISCOUNTS

Line 562: FROM ra_terms_lines_discounts rtd

558: l_trx_where_clause := l_trx_where_clause || ' AND TRUNC(arps.due_date) <= trunc(:v_transaction_due_date)';
559: ELSE -- FOR ESD ENABLED AGREEMENTS, modified the where clause for selecting invoices which are elegible for discount
560: l_trx_where_clause := l_trx_where_clause || ' AND ( arps.terms_sequence_number in (
561: select rtd.sequence_num
562: FROM ra_terms_lines_discounts rtd
563: where rtd.term_id = ARPS.TERM_ID
564: AND rtd.sequence_num = ARPS.TERMS_SEQUENCE_NUMBER
565: and (:v_transaction_due_date) <= ((arps.trx_date)+rtd.discount_days)) OR
566: (( (arps.due_date) <= (:v_transaction_due_date))))';

Line 3659: FROM ra_terms_lines_discounts rtd

3655: AND ARPS.customer_Trx_id = trx.customer_Trx_id
3656: --AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE
3657: AND ( arps.terms_sequence_number in (
3658: select rtd.sequence_num
3659: FROM ra_terms_lines_discounts rtd
3660: where rtd.term_id = ARPS.TERM_ID
3661: AND rtd.sequence_num = ARPS.TERMS_SEQUENCE_NUMBER
3662: and (g_batch_details.TRANSACTION_DUE_DATE) <= ((arps.trx_date)+rtd.discount_days)) OR
3663: (((arps.due_date)<=(g_batch_details.TRANSACTION_DUE_DATE))))

Line 4008: FROM ra_terms_lines_discounts rtd

4004: FROM ar_payment_schedules ps
4005: WHERE ps.customer_trx_id = p_cust_trx_id
4006: AND ( ( get_esd_flag(g_batch_details.batch_id)='Y' AND ps.terms_sequence_number in (
4007: select rtd.sequence_num
4008: FROM ra_terms_lines_discounts rtd
4009: where rtd.term_id = ps.TERM_ID
4010: AND rtd.sequence_num = ps.TERMS_SEQUENCE_NUMBER
4011: and (g_batch_details.TRANSACTION_DUE_DATE) <= ((ps.trx_date)+rtd.discount_days)) OR
4012: (( (ps.due_date) <= (g_batch_details.TRANSACTION_DUE_DATE))))

Line 4048: FROM ra_terms_lines_discounts rtd

4044: AND due_date between g_agr_start_date and g_agr_end_date
4045: AND ps.status = 'OP'
4046: AND ( ps.terms_sequence_number in (
4047: select rtd.sequence_num
4048: FROM ra_terms_lines_discounts rtd
4049: where rtd.term_id = ps.TERM_ID
4050: AND rtd.sequence_num = ps.TERMS_SEQUENCE_NUMBER
4051: and (g_batch_details.TRANSACTION_DUE_DATE) <= ((ps.trx_date)+rtd.discount_days)) OR
4052: (( (ps.due_date) <= (g_batch_details.TRANSACTION_DUE_DATE))))

Line 4472: FROM ra_terms_lines_discounts rtd

4468: AND ARPS.customer_Trx_id = trx.customer_Trx_id
4469: --AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE
4470: AND ( arps.terms_sequence_number in (
4471: select rtd.sequence_num
4472: FROM ra_terms_lines_discounts rtd
4473: where rtd.term_id = ARPS.TERM_ID
4474: AND rtd.sequence_num = ARPS.TERMS_SEQUENCE_NUMBER
4475: and (g_batch_details.TRANSACTION_DUE_DATE) <= ((arps.trx_date)+rtd.discount_days)) OR
4476: (((arps.due_date)<=(g_batch_details.TRANSACTION_DUE_DATE))))