APPS.OZF_AR_PAYMENT_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 645: FROM ar_payment_schedules

641: l_payment_schedule_id NUMBER;
642:
643: CURSOR csr_payment_schedule(cv_customer_trx_id IN NUMBER) IS
644: SELECT payment_schedule_id
645: FROM ar_payment_schedules
646: WHERE customer_trx_id = cv_customer_trx_id;
647:
648: BEGIN
649: -------------------- initialize -----------------------

Line 761: FROM ar_payment_schedules

757: l_payment_method VARCHAR2(60);
758:
759: CURSOR csr_payment_schedule(cv_customer_trx_id IN NUMBER) IS
760: SELECT payment_schedule_id
761: FROM ar_payment_schedules
762: WHERE customer_trx_id = cv_customer_trx_id;
763:
764: CURSOR csr_trx_balance(cv_customer_trx_id IN NUMBER) IS
765: SELECT ABS(amount_due_remaining)

Line 766: FROM ar_payment_schedules

762: WHERE customer_trx_id = cv_customer_trx_id;
763:
764: CURSOR csr_trx_balance(cv_customer_trx_id IN NUMBER) IS
765: SELECT ABS(amount_due_remaining)
766: FROM ar_payment_schedules
767: WHERE customer_trx_id = cv_customer_trx_id;
768:
769: -- Added For Rule Based Settlement ER
770: CURSOR csr_claim_trx(cv_claim_id IN NUMBER) IS

Line 1197: FROM ar_payment_schedules

1193: CURSOR csr_credit_amount(cv_customer_trx_id IN NUMBER) IS
1194: SELECT SUM(NVL(amount_line_items_remaining, 0))
1195: , SUM(NVL(tax_remaining, 0))
1196: , SUM(NVL(freight_remaining, 0))
1197: FROM ar_payment_schedules
1198: WHERE customer_trx_id = cv_customer_trx_id;
1199:
1200: --Bugfix 8452740: Added flexfields to pass information from TM to AR
1201: CURSOR csr_claim_flex_flds (cv_cust_trx_id NUMBER) IS

Line 1927: , ar_payment_schedules pay

1923: pay.amount_line_items_remaining,
1924: pay.tax_remaining,
1925: pay.freight_remaining
1926: FROM ar_receivable_applications rec
1927: , ar_payment_schedules pay
1928: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
1929: AND rec.cash_receipt_id = cv_cash_receipt_id
1930: AND pay.customer_trx_id = cv_customer_trx_id
1931: AND rec.application_ref_type = 'CLAIM'

Line 2644: , ar_payment_schedules pay

2640: , rec.secondary_application_ref_id
2641: , rec.application_ref_reason
2642: , rec.customer_reference
2643: FROM ar_receivable_applications rec
2644: , ar_payment_schedules pay
2645: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2646: AND rec.cash_receipt_id = cv_cash_receipt_id
2647: AND pay.customer_trx_id = cv_customer_trx_id
2648: AND rec.display = 'Y';

Line 2681: , ar_payment_schedules pay

2677:
2678: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2679: SELECT rec.cash_receipt_id
2680: FROM ar_receivable_applications_all rec
2681: , ar_payment_schedules pay
2682: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
2683: AND pay.customer_trx_id = cv_invoice_id;
2684:
2685: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER

Line 3333: , ar_payment_schedules pay

3329: , rec.secondary_application_ref_id
3330: , rec.application_ref_reason
3331: , rec.customer_reference
3332: FROM ar_receivable_applications rec
3333: , ar_payment_schedules pay
3334: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3335: AND rec.cash_receipt_id = cv_cash_receipt_id
3336: AND pay.customer_trx_id = cv_customer_trx_id
3337: AND rec.display = 'Y';

Line 3357: , ar_payment_schedules pay

3353:
3354: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
3355: SELECT rec.cash_receipt_id
3356: FROM ar_receivable_applications_all rec
3357: , ar_payment_schedules pay
3358: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3359: AND pay.customer_trx_id = cv_invoice_id;
3360:
3361: CURSOR csr_old_claim_investigation( cv_cash_receipt_id IN NUMBER

Line 3727: , ar_payment_schedules pay

3723: , rec.secondary_application_ref_id
3724: , sum(rec.amount_applied) amount_applied
3725: , sum(rec.amount_applied_from) amount_applied_from --4684931
3726: FROM ar_receivable_applications rec
3727: , ar_payment_schedules pay
3728: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3729: AND rec.cash_receipt_id = cv_cash_receipt_id
3730: AND pay.customer_trx_id = cv_customer_trx_id
3731: AND rec.application_ref_type = 'CLAIM'

Line 3748: , ar_payment_schedules pay

3744: , rec.amount_applied
3745: , rec.amount_applied_from --4684931
3746: , pay.amount_due_remaining
3747: FROM ar_receivable_applications rec
3748: , ar_payment_schedules pay
3749: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
3750: AND rec.cash_receipt_id = cv_cash_receipt_id
3751: AND pay.customer_trx_id = cv_customer_trx_id
3752: AND rec.application_ref_type = 'CLAIM'

Line 4603: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all

4599: l_settlement_amount NUMBER := NULL ;
4600:
4601: -- Start Fix for Bug4324426
4602: CURSOR csr_ded_details(p_customer_trx_id IN NUMBER) IS
4603: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all
4604: WHERE source_object_id = customer_trx_id
4605: AND source_object_class = class
4606: AND claim_class = 'DEDUCTION'
4607: AND cust_account_id = customer_id

Line 4641: , ar_payment_schedules pay

4637: , rec.secondary_application_ref_id
4638: , sum(rec.amount_applied) amount_applied
4639: , sum(rec.amount_applied_from) amount_applied_from --4684931
4640: FROM ar_receivable_applications rec
4641: , ar_payment_schedules pay
4642: WHERE rec.applied_payment_schedule_id = pay.payment_schedule_id
4643: AND rec.cash_receipt_id = cv_cash_receipt_id
4644: AND pay.customer_trx_id = cv_customer_trx_id
4645: AND rec.application_ref_type = 'CLAIM'

Line 4665: FROM ar_payment_schedules_all

4661: WHERE secondary_application_ref_id = cv_claim_id;
4662:
4663: CURSOR csr_trx_amt(cv_customer_trx_id IN NUMBER) IS
4664: SELECT amount_applied
4665: FROM ar_payment_schedules_all
4666: WHERE customer_trx_id = cv_customer_trx_id;
4667:
4668: l_source_obt_class VARCHAR2(10);
4669: l_receipt_amt NUMBER;