APPS.OZF_CLAIM_GRP dependencies on AR_CASH_RECEIPTS

Line 503: FROM ar_cash_receipts

499: l_sql_stmt VARCHAR2(1000);
500:
501: CURSOR csr_get_receipt_num(cv_cash_receipt_id IN NUMBER) IS
502: SELECT receipt_number
503: FROM ar_cash_receipts
504: WHERE cash_receipt_id = cv_cash_receipt_id;
505:
506: CURSOR csr_get_trx_num(cv_customer_trx_id IN NUMBER) IS
507: SELECT trx_number

Line 2648: FROM ar_cash_receipts

2644: WHERE claim_id = cv_claim_id;
2645:
2646: CURSOR csr_ar_receipt(cv_receipt_id IN NUMBER) IS
2647: SELECT receipt_number
2648: FROM ar_cash_receipts
2649: WHERE cash_receipt_id = cv_receipt_id;
2650:
2651: CURSOR csr_return_claim_info(cv_claim_id IN NUMBER) IS
2652: SELECT c.claim_id