DBA Data[Home] [Help]

APPS.OZF_CLAIM_GRP dependencies on AR_CASH_RECEIPTS_ALL

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