APPS.ASP_ALERTS_INVOICE dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 86: from IEX_DEL_ALERTS_PUB_V d, AR_PAYMENT_SCHEDULES_ALL ps

82: and rownum < 2;
83:
84: CURSOR getDelinquencyDeltaRun is
85: Select d.delinquency_id
86: from IEX_DEL_ALERTS_PUB_V d, AR_PAYMENT_SCHEDULES_ALL ps
87: where trunc(d.last_update_date) between trunc(l_program_ref_date+1)
88: and trunc(l_current_run_ref_date)
89: and ps.payment_schedule_id = d.payment_schedule_id
90: and ps.class = 'INV' and ps.status = 'OP';