40:
41: l_org_id NUMBER :=0;
42: l_claim_id NUMBER := 0;
43: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
44: l_ou_le_info xle_businessinfo_grp.OU_LE_Tbl_Type;
45:
46: CURSOR claim_org_id_csr IS
47: SELECT claim_id, org_id
48: FROM ozf_claims_all
61: EXIT when claim_org_id_csr%NOTFOUND;
62:
63: -- Fetch the legal entity id into l_legal_entity_id from API
64:
65: xle_businessinfo_grp.get_operatingunit_info (
66: x_return_status => l_return_status
67: ,x_msg_data => l_msg_data
68: ,p_operating_unit => l_org_id
69: ,p_legal_entity_id => NULL