APPS.IEX_BUS_EVENT_SUB_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 577: ar_receivable_applications ra,

573:
574: CURSOR select_ps_cm (p_ra_id IN NUMBER ) IS
575: SELECT trx_ps.*
576: FROM ar_payment_schedules trx_ps,
577: ar_receivable_applications ra,
578: ar_payment_schedules rcpt_ps
579: WHERE ra.receivable_application_id = p_ra_id
580: AND ra.status in ('APP')
581: AND ra.payment_schedule_id = rcpt_ps.payment_schedule_id

Line 601: FROM ar_receivable_applications ra,

597:
598:
599: CURSOR select_ps_auto_rec (p_request_id IN NUMBER) IS
600: SELECT ps.*
601: FROM ar_receivable_applications ra,
602: ar_payment_schedules ps
603: WHERE ra.request_id = p_request_id
604: AND ra.status IN('APP','UNAPP')
605: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;