APPS.OZF_AR_SETTLEMENT_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 852: FROM ar_payment_schedules

848: l_trx_number trx_number_type;
849:
850: CURSOR csr_cm_trx_data(cv_trx_number IN VARCHAR2) IS
851: SELECT distinct customer_trx_id
852: FROM ar_payment_schedules
853: WHERE trx_number = cv_trx_number
854: AND class = 'CM';
855:
856: CURSOR csr_dm_trx_data(cv_trx_number IN VARCHAR2) IS

Line 858: FROM ar_payment_schedules

854: AND class = 'CM';
855:
856: CURSOR csr_dm_trx_data(cv_trx_number IN VARCHAR2) IS
857: SELECT distinct customer_trx_id
858: FROM ar_payment_schedules
859: WHERE trx_number = cv_trx_number
860: AND class in ( 'DM', 'CB', 'INV');
861:
862: CURSOR csr_cb_trx_data(cv_trx_number IN VARCHAR2) IS

Line 864: FROM ar_payment_schedules

860: AND class in ( 'DM', 'CB', 'INV');
861:
862: CURSOR csr_cb_trx_data(cv_trx_number IN VARCHAR2) IS
863: SELECT distinct customer_trx_id
864: FROM ar_payment_schedules
865: WHERE trx_number = cv_trx_number;
866:
867: -- Cursor to verify Write_Off number
868: CURSOR csr_write_off_trx(cv_trx_number IN VARCHAR2) IS

Line 902: from ar_payment_schedules pay

898: , pay.trx_number --"settlement_number"
899: , pay.trx_date --"settlement_date"
900: , sum(pay.amount_due_original) --"settlement_amount"
901: , pay.status
902: from ar_payment_schedules pay
903: where pay.customer_trx_id = cv_trx_id
904: group by pay.customer_trx_id, pay.cust_trx_type_id,pay.trx_number,
905: pay.trx_date , pay.status;
906:

Line 915: , ar_payment_schedules pay

911: , adj.apply_date --"settlement_date"
912: , adj.amount --"settlement_amount"
913: , pay.status --"status_code"
914: FROM ar_adjustments adj
915: , ar_payment_schedules pay
916: WHERE adj.payment_schedule_id = pay.payment_schedule_id
917: AND adj.adjustment_id = cv_trx_id;
918:
919: CURSOR csr_ar_settle_rec_writeoff(cv_cash_receipt_id IN NUMBER) IS

Line 927: , ar_payment_schedules pay

923: , rec.apply_date --"settlement_date"
924: , rec.amount_applied --"settlement_amount"
925: , pay.status --"status_code"
926: FROM ar_receivable_applications rec
927: , ar_payment_schedules pay
928: WHERE rec.cash_receipt_id = cv_cash_receipt_id
929: AND rec.applied_payment_schedule_id = -3
930: AND rec.applied_payment_schedule_id = pay.payment_schedule_id;
931: