APPS.FUN_NET_ARAP_PKG dependencies on RA_CUST_TRX_TYPES

Line 504: ra_cust_trx_types_all rctt,

500: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_trx_select_clause);
501: l_trx_from_clause :=
502: ' FROM ra_customer_trx_all rct,
503: ar_payment_schedules_all arps,
504: ra_cust_trx_types_all rctt,
505: fun_net_customers_all fnc ';
506: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_trx_from_clause);
507: -- Build the WHERE clause --
508: /* Only select the transactions where the due date is on or before the Tnx due date in the batch */

Line 3653: RA_CUST_TRX_TYPES ctype

3649: FROM FUN_NET_AR_TXNS ftxn,
3650: RA_CUSTOMER_TRX trx,
3651: AR_PAYMENT_SCHEDULES ARPS,
3652: AR_RECEIPT_METHODS arm,
3653: RA_CUST_TRX_TYPES ctype
3654: WHERE ftxn.customer_trx_id = trx.customer_trx_id
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 (

Line 3702: RA_CUST_TRX_TYPES ctype

3698: FROM FUN_NET_AR_TXNS ftxn,
3699: RA_CUSTOMER_TRX trx,
3700: AR_PAYMENT_SCHEDULES ARPS,
3701: AR_RECEIPT_METHODS arm,
3702: RA_CUST_TRX_TYPES ctype
3703: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3704: AND ARPS.customer_Trx_id = trx.customer_Trx_id
3705: AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE
3706: AND ARPS.DUE_DATE between g_agr_start_date and g_agr_end_date

Line 4466: RA_CUST_TRX_TYPES ctype

4462: FROM FUN_NET_AR_TXNS ftxn,
4463: RA_CUSTOMER_TRX trx,
4464: AR_PAYMENT_SCHEDULES ARPS,
4465: AR_RECEIPT_METHODS arm,
4466: RA_CUST_TRX_TYPES ctype
4467: WHERE ftxn.customer_trx_id = trx.customer_trx_id
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 (

Line 4515: RA_CUST_TRX_TYPES ctype

4511: FROM FUN_NET_AR_TXNS ftxn,
4512: RA_CUSTOMER_TRX trx,
4513: AR_PAYMENT_SCHEDULES ARPS,
4514: AR_RECEIPT_METHODS arm,
4515: RA_CUST_TRX_TYPES ctype
4516: WHERE ftxn.customer_trx_id = trx.customer_trx_id
4517: AND ARPS.customer_Trx_id = trx.customer_Trx_id
4518: AND ARPS.DUE_DATE <= g_batch_details.TRANSACTION_DUE_DATE
4519: AND ARPS.DUE_DATE between g_agr_start_date and g_agr_end_date