DBA Data[Home] [Help]

APPS.OZF_MASS_SETTLEMENT_PVT dependencies on RA_CUSTOMER_TRX

Line 985: FROM ra_customer_trx

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