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 1942: from ar_payment_schedules_all

1938:
1939: begin--29/12
1940: select org_id,customer_id,customer_site_use_id
1941: into l_org_id,l_cust_acct_id,l_cust_site_use_id --29/12
1942: from ar_payment_schedules_all
1943: where payment_schedule_id= p_object_id_tbl(i);
1944:
1945: IEX_DEBUG_PUB.LOGMESSAGE('Org_id--->'||l_org_id);
1946: IEX_DEBUG_PUB.LOGMESSAGE('Cust_account_id-->'||l_cust_acct_id);