DBA Data[Home] [Help]

APPS.OZF_CLAIM_GRP dependencies on RA_CUSTOMER_TRX_ALL

Line 3201: AND cust_account_id = (SELECT bill_to_customer_id from ra_customer_trx_all

3197: SELECT claim_id, claim_number, customer_ref_number FROM ozf_claims
3198: WHERE source_object_id = cv_customer_trx_id
3199: AND claim_id = root_claim_id
3200: AND root_claim_id IS NOT NULL
3201: AND cust_account_id = (SELECT bill_to_customer_id from ra_customer_trx_all
3202: WHERE customer_trx_id = cv_customer_trx_id);
3203:
3204: BEGIN
3205: /*