eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CM_VAL_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 650: FROM ar_receivable_applications ra,

646: p_return_status OUT NOCOPY VARCHAR2
647: ) IS
648: CURSOR rec_apppln IS
649: SELECT ra.applied_customer_trx_id, ra.applied_payment_schedule_id, ra.gl_date
650: FROM ar_receivable_applications ra,
651: ar_payment_schedules ps
652: WHERE ra.applied_payment_schedule_id = ps.payment_schedule_id
653: AND ra.receivable_application_id = p_ra_id
654: AND ra.display = 'Y'

Line 706: FROM ar_receivable_applications ra

702: p_applied_payment_schedule_id IS NOT NULL
703: THEN
704: SELECT receivable_application_id, gl_date
705: INTO p_receivable_application_id, p_apply_gl_date
706: FROM ar_receivable_applications ra
707: WHERE ra.customer_trx_id = p_cm_customer_trx_id
708: AND ra.applied_payment_schedule_id = p_applied_payment_schedule_id
709: AND ra.display = 'Y'
710: AND ra.status = 'APP'

Line 753: FROM ar_receivable_applications

749: --get the gl_date for the application
750: BEGIN
751: SELECT gl_date, customer_trx_id
752: INTO l_apply_gl_date, p_cm_customer_trx_id
753: FROM ar_receivable_applications
754: WHERE receivable_application_id =
755: p_receivable_application_id;
756: EXCEPTION
757: WHEN OTHERS THEN

Line 820: FROM AR_RECEIVABLE_APPLICATIONS ra

816: ar_cm_api_pub.original_cm_unapp_info.receivable_application_id IS NOT NULL
817: THEN
818: SELECT count(*)
819: INTO l_valid
820: FROM AR_RECEIVABLE_APPLICATIONS ra
821: WHERE ra.receivable_application_id = p_receivable_application_id
822: and ra.display = 'Y'
823: and ra.status = p_application_type
824: and ra.application_type = 'CM';