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 2672: FROM ar_cash_receipts

2668: WHERE claim_id = cv_claim_id;
2669:
2670: CURSOR csr_ar_receipt(cv_receipt_id IN NUMBER) IS
2671: SELECT receipt_number
2672: FROM ar_cash_receipts
2673: WHERE cash_receipt_id = cv_receipt_id;
2674:
2675: CURSOR csr_return_claim_info(cv_claim_id IN NUMBER) IS
2676: SELECT c.claim_id

Line 2755: ar_cash_receipts_all cr

2751: ,p_cash_receipt_id IN NUMBER ) IS
2752: SELECT ra.cash_receipt_id,
2753: cr.receipt_number
2754: FROM ar_receivable_applications_all ra,
2755: ar_cash_receipts_all cr
2756: WHERE ra.cash_receipt_id = cr.cash_receipt_id
2757: AND ra.cash_receipt_id <> p_cash_receipt_id
2758: AND ra.application_ref_type = 'CLAIM'
2759: AND ra.secondary_application_ref_id = p_claim_id