APPS.OZF_CLAIMS_INT_PVT dependencies on OZF_CLAIM_LINES_INT_ALL

Line 2376: FROM ozf_claim_lines_int_all

2372: l_claim_int_rec c_claim_int%ROWTYPE;
2373:
2374: CURSOR c_claim_line_int(cv_claim_id IN NUMBER) IS
2375: SELECT *
2376: FROM ozf_claim_lines_int_all
2377: WHERE interface_claim_id = cv_claim_id;
2378: l_line_int_rec c_claim_line_int%ROWTYPE;
2379:
2380: l_api_name CONSTANT VARCHAR2(30) := 'Import_Claim';

Line 2987: delete FROM ozf_claim_lines_int_all a

2983: MO_GLOBAL.set_policy_context('S',p_org_id);
2984: END IF;
2985:
2986: -- Clean up lines table.
2987: delete FROM ozf_claim_lines_int_all a
2988: where exists
2989: (select 1 from ozf_claims_int_all b
2990: where b.claim_id is not null
2991: and b.interface_claim_id = a.interface_claim_id);