APPS.OZF_AR_PAYMENT_PVT dependencies on OZF_CLAIM_LINES

Line 2095: FROM ozf_claim_lines

2091: , credit_to
2092: , SUM(quantity) qty
2093: , AVG(rate) rate
2094: , SUM(NVL(claim_currency_amount,0)) amount
2095: FROM ozf_claim_lines
2096: WHERE claim_id = cv_claim_id
2097: AND source_object_id = cv_inv_id
2098: GROUP BY source_object_id,source_object_line_id,credit_to;
2099: l_trx_lines csr_claim_line_invoice%ROWTYPE;

Line 2250: FROM ozf_claim_lines

2246: l_old_applied_invoice csr_old_applied_amount%ROWTYPE;
2247:
2248: CURSOR csr_count_claim_line(cv_claim_id IN NUMBER) IS
2249: SELECT COUNT(claim_line_id)
2250: FROM ozf_claim_lines
2251: WHERE claim_id = cv_claim_id;
2252:
2253: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS
2254: SELECT rec.cash_receipt_id

Line 2878: FROM ozf_claim_lines

2874: l_old_applied_invoice csr_old_applied_amount%ROWTYPE;
2875:
2876: CURSOR csr_count_claim_line(cv_claim_id IN NUMBER) IS
2877: SELECT COUNT(claim_line_id)
2878: FROM ozf_claim_lines
2879: WHERE claim_id = cv_claim_id;
2880:
2881: CURSOR csr_claim_line_invoice(cv_claim_id IN NUMBER) IS
2882: SELECT source_object_class

Line 2885: FROM ozf_claim_lines

2881: CURSOR csr_claim_line_invoice(cv_claim_id IN NUMBER) IS
2882: SELECT source_object_class
2883: , source_object_id
2884: , source_object_line_id
2885: FROM ozf_claim_lines
2886: WHERE claim_id = cv_claim_id;
2887:
2888:
2889: CURSOR csr_invoice_apply_receipt(cv_invoice_id IN NUMBER) IS

Line 2913: FROM ozf_claim_lines_all

2909: WHERE customer_trx_line_id = cv_invoice_line_id;
2910:
2911: CURSOR csr_claim_lines(cv_claim_id IN NUMBER) IS
2912: SELECT source_object_id, sum(claim_currency_amount) amt
2913: FROM ozf_claim_lines_all
2914: WHERE claim_id = cv_claim_id
2915: GROUP BY source_object_id;
2916: l_lines_rec csr_claim_lines%ROWTYPE;
2917: