APPS.AR_CM_VAL_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 651: FROM ar_receivable_applications ra,

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

Line 707: FROM ar_receivable_applications ra

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

Line 754: FROM ar_receivable_applications

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

Line 821: FROM AR_RECEIVABLE_APPLICATIONS ra

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