DBA Data[Home] [Help]

APPS.OZF_OM_VALIDATION_PVT dependencies on OZF_CLAIMS

Line 656: FROM ozf_claims

652: /*
653: CURSOR csr_claim(p_claim_id IN NUMBER) IS
654: SELECT cust_account_id
655: , currency_code
656: FROM ozf_claims
657: WHERE claim_id = p_claim_id;
658:
659: l_cust_account_id NUMBER;
660: l_claim_currency VARCHAR2(15);

Line 793: FROM ozf_claims

789: CURSOR csr_claim(p_claim_id IN NUMBER) IS
790: SELECT cust_account_id
791: , order_type_id
792: , currency_code
793: FROM ozf_claims
794: WHERE claim_id = p_claim_id;
795:
796: CURSOR csr_product_name(cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS
797: SELECT description