APPS.ARI_UTILITIES dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 2126: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites

2122: --------------------------------------------------------------------
2123:
2124: select aps.customer_id,sites.CUST_ACCT_SITE_ID,aps.trx_number
2125: into l_customer_id,l_customer_acct_site_id,l_trx_number
2126: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites
2127: where aps.customer_trx_id = l_customer_trx_id
2128: and aps.org_id = l_org_id
2129: and sites.site_use_id = aps.customer_site_use_id;
2130:

Line 2576: from ar_payment_schedules_all aps,ra_terms t

2572: ---------------------------------------------------------------------------
2573:
2574: select aps.trx_number,aps.amount_due_original,aps.invoice_currency_code,aps.due_date,t.name,t.description,aps.class
2575: into l_trx_number,l_trx_amt_due,l_trx_curr_code,l_trx_due_date,l_trx_term_name,l_trx_term_desc,l_trx_type
2576: from ar_payment_schedules_all aps,ra_terms t
2577: where aps.trx_number = l_trx_number
2578: and aps.customer_id = p_customer_id
2579: and aps.term_id = t.term_id(+);
2580:

Line 2971: from ar_payment_schedules_all

2967: BEGIN
2968: p_result := 'N';
2969: if(p_cust_trx_id is null) then
2970: select customer_trx_id into l_cust_trx_id
2971: from ar_payment_schedules_all
2972: where payment_schedule_id = p_payment_schedule_id
2973: and trx_number = p_txn_no;
2974: else
2975: l_cust_trx_id := p_cust_trx_id;

Line 2979: from ar_payment_schedules_all ps, ra_customer_trx_all ra

2975: l_cust_trx_id := p_cust_trx_id;
2976: end if;
2977: if(p_txn_type<>'PMT') THEN
2978: Select (sysdate - ps.TRX_DATE), ra.Printing_option into l_txn_difference, l_print_flag
2979: from ar_payment_schedules_all ps, ra_customer_trx_all ra
2980: where ps.CUSTOMER_TRX_ID= ra.CUSTOMER_TRX_ID
2981: and ps.trx_number=p_txn_no
2982: and ps.CUSTOMER_TRX_ID = l_cust_trx_id;
2983: else

Line 2984: Select (sysdate - TRX_DATE) into l_txn_difference from ar_payment_schedules_all

2980: where ps.CUSTOMER_TRX_ID= ra.CUSTOMER_TRX_ID
2981: and ps.trx_number=p_txn_no
2982: and ps.CUSTOMER_TRX_ID = l_cust_trx_id;
2983: else
2984: Select (sysdate - TRX_DATE) into l_txn_difference from ar_payment_schedules_all
2985: where trx_number=p_txn_no
2986: and PAYMENT_SCHEDULE_ID = p_payment_schedule_id;
2987: end if;
2988: IF (PG_DEBUG = 'Y') THEN