APPS.IEX_BUS_EVENT_SUB_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 581: ar_receivable_applications ra,

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

Line 605: FROM ar_receivable_applications ra,

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