APPS.ARP_CHARGEBACK_COVER dependencies on AR_PAYMENT_SCHEDULES

Line 116: l_installment ar_payment_schedules.terms_sequence_number%TYPE;

112: l_app_gl_date_prof VARCHAR2(240); -- bug 2621114
113: l_default_gl_date DATE;
114: l_defaulting_rule_used VARCHAR2(50);
115: l_customer_trx_id NUMBER;
116: l_installment ar_payment_schedules.terms_sequence_number%TYPE;
117: l_new_claim_num ar_receivable_applications.application_ref_num%TYPE;
118: l_doc_sequence_id NUMBER := NULL;
119: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE := NULL;
120: l_trx_number ra_customer_trx.trx_number%TYPE;

Line 213: , ar_payment_schedules ps

209: , l_exchange_rate_type
210: , l_exchange_rate_date
211: , l_bill_to_site_use_id
212: FROM ar_cash_receipts cr
213: , ar_payment_schedules ps
214: , ar_cash_receipt_history crh
215: WHERE cr.cash_receipt_id = crh.cash_receipt_id(+)
216: AND crh.first_posted_record_flag(+) = 'Y'
217: AND cr.cash_receipt_id = ps.cash_receipt_id(+)

Line 377: FROM ar_payment_schedules ps

373: , l_global_attribute_rec.global_attribute17
374: , l_global_attribute_rec.global_attribute18
375: , l_global_attribute_rec.global_attribute19
376: , l_global_attribute_rec.global_attribute20
377: FROM ar_payment_schedules ps
378: , ar_receivable_applications app
379: WHERE app.applied_payment_schedule_id = ps.payment_schedule_id
380: AND app.secondary_application_ref_id = p_chargeback_rec.secondary_application_ref_id
381: AND app.application_ref_type = p_chargeback_rec.application_ref_type