44: l_dummy NUMBER;
45:
46: CURSOR c_id IS
47: SELECT OZF_CLAIM_LINES_INT_ALL_s.NEXTVAL
48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT 1 FROM dual
52: WHERE EXISTS (SELECT 1 FROM OZF_CLAIM_LINES_INT_ALL
47: SELECT OZF_CLAIM_LINES_INT_ALL_s.NEXTVAL
48: FROM dual;
49:
50: CURSOR c_id_exists (l_id IN NUMBER) IS
51: SELECT 1 FROM dual
52: WHERE EXISTS (SELECT 1 FROM OZF_CLAIM_LINES_INT_ALL
53: WHERE INTERFACE_CLAIM_LINE_ID = l_id);
54:
55: BEGIN