DBA Data[Home] [Help]

APPS.OZF_CLAIMS_INT_PVT dependencies on DUAL

Line 64: FROM dual;

60: l_claim_int_rec claims_int_rec_type := p_claims_int_rec;
61:
62: CURSOR c_id IS
63: SELECT OZF_CLAIMS_INT_ALL_s.NEXTVAL
64: FROM dual;
65:
66: CURSOR c_id_exists (l_id IN NUMBER) IS
67: SELECT 1 FROM dual
68: WHERE EXISTS (SELECT 1 FROM OZF_CLAIMS_INT_ALL

Line 67: SELECT 1 FROM dual

63: SELECT OZF_CLAIMS_INT_ALL_s.NEXTVAL
64: FROM dual;
65:
66: CURSOR c_id_exists (l_id IN NUMBER) IS
67: SELECT 1 FROM dual
68: WHERE EXISTS (SELECT 1 FROM OZF_CLAIMS_INT_ALL
69: WHERE INTERFACE_CLAIM_ID = l_id);
70:
71: BEGIN