APPS.IEX_DELINQUENCY_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 458: AR_PAYMENT_SCHEDULES ARPS,

454: IDB.score_object_id,
455: IDS.del_status
456: FROM HZ_CUST_ACCOUNTS HZCA,
457: IEX_DEL_BUFFERS IDB,
458: AR_PAYMENT_SCHEDULES ARPS,
459: IEX_DEL_STATUSES IDS
460: WHERE
461: NOT EXISTS
462: (Select 1

Line 939: -- get customer_site_use_id from ar_payment_schedules

935: /* ================= Debug Message =========================*/
936:
937:
938: -- clchang updated 04/18/2003 for BILL_TO
939: -- get customer_site_use_id from ar_payment_schedules
940:
941: Begin
942: -- Simple Insert for Payment Schedule Id
943: INSERT INTO IEX_DELINQUENCIES_ALL

Line 986: AR_PAYMENT_SCHEDULES ARPS ,

982: IDB.score_value ,
983: p_Request_id
984: FROM HZ_CUST_ACCOUNTS HZCA ,
985: IEX_DEL_BUFFERS IDB ,
986: AR_PAYMENT_SCHEDULES ARPS ,
987: IEX_DEL_STATUSES IDS
988: WHERE
989: NOT EXISTS
990: (Select 1

Line 2015: from ar_payment_schedules_all

2011:
2012: begin--29/12
2013: select org_id,customer_id,customer_site_use_id,customer_trx_id--Added for Bug 8517550 14-May-2009 barathsr
2014: into l_org_id,l_cust_acct_id,l_cust_site_use_id,l_cust_trx_id --29/12
2015: from ar_payment_schedules_all
2016: where payment_schedule_id= p_object_id_tbl(i);
2017:
2018: IEX_DEBUG_PUB.LOGMESSAGE('Org_id--->'||l_org_id);
2019: IEX_DEBUG_PUB.LOGMESSAGE('Cust_account_id-->'||l_cust_acct_id);