APPS.ARI_UTILITIES dependencies on AR_PAYMENT_SCHEDULES

Line 1656: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number

1652: and acct_sites_count.cust_account_id=p_customer_id
1653: and INSTR(ARI_UTILITIES.GET_SITE_USE_CODE(acct_sites_count.CUST_ACCT_SITE_ID), 'BILL_TO')>0;
1654:
1655: select count(*) into l_flag from(
1656: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number
1657: and CUSTOMER_SITE_USE_ID in
1658: (
1659: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where
1660: party_id=p_party_id

Line 1726: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites

1722: --------------------------------------------------------------------
1723:
1724: select aps.customer_id,sites.CUST_ACCT_SITE_ID,trx_number
1725: into l_customer_id,l_customer_acct_site_id,l_trx_number
1726: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites
1727: where aps.customer_trx_id = l_customer_trx_id
1728: and aps.org_id = l_org_id
1729: and sites.site_use_id = aps.customer_site_use_id;
1730:

Line 1993: from ar_payment_schedules_all aps,ra_terms t

1989: ---------------------------------------------------------------------------
1990:
1991: select aps.trx_number,aps.amount_due_original,aps.invoice_currency_code,aps.due_date,t.name,t.description
1992: into l_trx_number,l_inv_amt_due,l_inv_curr_code,l_inv_due_date,l_term_nanme,l_term_desc
1993: from ar_payment_schedules_all aps,ra_terms t
1994: where aps.customer_trx_id = l_customer_trx_id
1995: and aps.customer_id = p_customer_id
1996: and aps.term_id = t.term_id(+);
1997:

Line 2160: FROM ar_payment_schedules ps

2156: SELECT payment_schedule_id,
2157: due_date,
2158: amount_in_dispute,
2159: dispute_date
2160: FROM ar_payment_schedules ps
2161: WHERE ps.customer_trx_id = p_customer_trx_id;
2162:
2163: cursor get_partyid(p_cust_acct_id number) is
2164: select party_id

Line 2175: from ar_payment_schedules

2171: where customer_trx_id = p_cust_trx_id;
2172:
2173: Cursor Get_paymentid(p_cust_trx_id number) Is
2174: select customer_id,payment_schedule_id
2175: from ar_payment_schedules
2176: where customer_trx_id = p_cust_trx_id;
2177:
2178: l_item_type VARCHAR2(100);
2179: l_customer_trx_id NUMBER;