DBA Data[Home] [Help]

APPS.OZF_CLAIM_GRP dependencies on RA_CUSTOMER_TRX_ALL

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: /*