DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on RA_CUSTOMER_TRX

Line 987: FROM ra_customer_trx

983: AND secondary_application_ref_id = cv_root_claim_id;
984:
985: CURSOR csr_payment_trx_number(cv_customer_trx_id IN NUMBER) IS
986: SELECT trx_number
987: FROM ra_customer_trx
988: WHERE customer_trx_id = cv_customer_trx_id;
989:
990: CURSOR csr_dm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
991: SELECT amount_applied, apply_date -- Fix for Bug 3091401. TM passes old apply date