APPS.OZF_CLAIM_GRP dependencies on RA_CUSTOMER_TRX

Line 508: FROM ra_customer_trx

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
508: FROM ra_customer_trx
509: WHERE customer_trx_id = cv_customer_trx_id;
510:
511: CURSOR csr_get_trx_class(cv_cust_trx_type_id IN NUMBER) IS
512: SELECT type

Line 3250: AND cust_account_id = (SELECT bill_to_customer_id from ra_customer_trx_all

3246: SELECT claim_id, claim_number, customer_ref_number FROM ozf_claims
3247: WHERE source_object_id = cv_customer_trx_id
3248: AND claim_id = root_claim_id
3249: AND root_claim_id IS NOT NULL
3250: AND cust_account_id = (SELECT bill_to_customer_id from ra_customer_trx_all
3251: WHERE customer_trx_id = cv_customer_trx_id);
3252:
3253: BEGIN
3254: /*