APPS.IEX_DELINQUENCY_PUB dependencies on AR_SYSTEM_PARAMETERS

Line 510: AR_SYSTEM_PARAMETERS ARP

506: --
507: --Bug5237039. Fix By LKKUMAR on 28-Aug-2006. Start.
508: CURSOR c_cust_account_id_1 IS
509: SELECT DISTINCT CUST_ACCOUNT_ID FROM AR_TRX_BAL_SUMMARY ARS,
510: AR_SYSTEM_PARAMETERS ARP
511: WHERE ARS.REFERENCE_1 IS Null
512: AND ARS.ORG_ID = ARP.ORG_ID
513: AND EXISTS (SELECT 1 FROM IEX_DELINQUENCIES_ALL IED WHERE
514: IED.STATUS IN ('DELINQUENT', 'PREDELINQUENT')

Line 520: AR_SYSTEM_PARAMETERS ARP

516: AND ARS.ORG_ID = IED.ORG_ID);
517:
518: CURSOR c_cust_account_id_n IS
519: SELECT DISTINCT CUST_ACCOUNT_ID FROM AR_TRX_BAL_SUMMARY ARS,
520: AR_SYSTEM_PARAMETERS ARP
521: WHERE ARS.REFERENCE_1 = 1
522: AND ARS.ORG_ID = ARP.ORG_ID
523: AND NOT EXISTS (SELECT 1 FROM IEX_DELINQUENCIES_ALL IED WHERE
524: IED.STATUS IN ('DELINQUENT', 'PREDELINQUENT')