DBA Data[Home] [Help]

APPS.OZF_OM_VALIDATION_PVT dependencies on OZF_CLAIMS

Line 715: FROM ozf_claims

711: /*
712: CURSOR csr_claim(p_claim_id IN NUMBER) IS
713: SELECT cust_account_id
714: , currency_code
715: FROM ozf_claims
716: WHERE claim_id = p_claim_id;
717:
718: l_cust_account_id NUMBER;
719: l_claim_currency VARCHAR2(15);

Line 852: FROM ozf_claims

848: CURSOR csr_claim(p_claim_id IN NUMBER) IS
849: SELECT cust_account_id
850: , order_type_id
851: , currency_code
852: FROM ozf_claims
853: WHERE claim_id = p_claim_id;
854:
855: CURSOR csr_product_name(cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS
856: SELECT description