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