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 1283: FROM ar_payment_schedules

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

Line 1664: FROM ar_payment_schedules

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

Line 2046: FROM ar_payment_schedules pay

2042: l_return_status VARCHAR2(1);
2043:
2044: CURSOR csr_calcuate_tax(cv_claim_id IN NUMBER) IS
2045: SELECT ABS(pay.tax_original)
2046: FROM ar_payment_schedules pay
2047: , ozf_settlement_docs sd
2048: WHERE pay.customer_trx_id = sd.settlement_id
2049: AND sd.claim_id = cv_claim_id;
2050: