APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 208: FROM ar_receivable_applications

204: BEGIN
205: Errcd := 0;
206: SELECT COUNT (*)
207: INTO tot_rec
208: FROM ar_receivable_applications
209: WHERE cash_receipt_id = cash_rcpt_id;
210: EXCEPTION
211: WHEN OTHERS THEN
212: Errcd := SQLCODE;

Line 616: FROM ar_receivable_applications

612: BEGIN
613:
614: SELECT MAX(apply_date)
615: INTO x_apply_date
616: FROM ar_receivable_applications
617: WHERE applied_payment_schedule_id = p_applied_payment_schedule_id
618: AND application_type = 'CASH'
619: AND status = 'APP'
620: AND confirmed_flag = 'Y'

Line 655: FROM ar_receivable_applications

651: p_int_diff_action,
652: p_int_writeoff_reason,
653: p_payment_date,
654: p_writeoff_date
655: FROM ar_receivable_applications
656: WHERE applied_payment_schedule_id = p_applied_payment_schedule_id
657: AND application_type = 'CASH'
658: AND status = 'APP'
659: AND confirmed_flag = 'Y'

Line 692: FROM ar_receivable_applications

688: SELECT applied_payment_schedule_id,
689: nvl(global_attribute3,0) calculated_interest,
690: nvl(global_attribute4,0) received_interest,
691: apply_date
692: FROM ar_receivable_applications
693: where cash_receipt_id = p_cash_receipt_id;
694:
695: ps_rec pay_sched%ROWTYPE;
696: revcode NUMBER;

Line 714: FROM ar_receivable_applications

710: ELSE
711: BEGIN
712: SELECT 1
713: INTO revcode
714: FROM ar_receivable_applications
715: WHERE applied_payment_schedule_id = ps_rec.applied_payment_schedule_id
716: AND status = 'APP'
717: AND cash_receipt_id <> p_cash_receipt_id
718: AND apply_date between ps_rec.apply_date and sysdate

Line 951: FROM ar_receivable_applications_all

947: END get_city_from_ra_addresses;
948:
949: PROCEDURE update_doc_status(p_cash_receipt_id IN NUMBER) IS
950: Cursor c1(p_rec_id NUMBER) is SELECT receivable_application_id, global_attribute12
951: FROM ar_receivable_applications_all
952: WHERE cash_receipt_id = p_rec_id;
953: BEGIN
954:
955: For rec in c1(p_cash_receipt_id) loop