APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 94: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;

90: ,x_return_status OUT NOCOPY VARCHAR2
91: )
92: IS
93: l_invoice_balance_due NUMBER;
94: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;
95:
96: CURSOR csr_invoice_balance(cv_trx_id IN NUMBER) IS
97: SELECT SUM(amount_due_remaining), trx_number
98: FROM ar_payment_schedules pay

Line 98: FROM ar_payment_schedules pay

94: l_trx_number AR_PAYMENT_SCHEDULES_ALL.TRX_NUMBER%TYPE;
95:
96: CURSOR csr_invoice_balance(cv_trx_id IN NUMBER) IS
97: SELECT SUM(amount_due_remaining), trx_number
98: FROM ar_payment_schedules pay
99: WHERE customer_trx_id = cv_trx_id
100: GROUP BY trx_number;
101:
102: BEGIN

Line 1281: FROM ar_payment_schedules

1277:
1278: CURSOR csr_trx_balance(cv_customer_trx_id IN NUMBER) IS
1279: SELECT SUM(amount_due_remaining),
1280: invoice_currency_code
1281: FROM ar_payment_schedules
1282: WHERE customer_trx_id = cv_customer_trx_id
1283: GROUP BY invoice_currency_code;
1284:
1285: l_gl_date_type VARCHAR2(30);

Line 1662: FROM ar_payment_schedules

1658: CURSOR csr_payment_ref_settlement(cv_customer_trx_id IN NUMBER) IS
1659: SELECT cust_trx_type_id
1660: , trx_number
1661: , status
1662: FROM ar_payment_schedules
1663: WHERE customer_trx_id = cv_customer_trx_id;
1664:
1665: l_automate_settlement VARCHAR2(1);
1666:

Line 2033: FROM ar_payment_schedules pay

2029: l_return_status VARCHAR2(1);
2030:
2031: CURSOR csr_calcuate_tax(cv_claim_id IN NUMBER) IS
2032: SELECT ABS(pay.tax_original)
2033: FROM ar_payment_schedules pay
2034: , ozf_settlement_docs sd
2035: WHERE pay.customer_trx_id = sd.settlement_id
2036: AND sd.claim_id = cv_claim_id;
2037: