DBA Data[Home] [Help]

APPS.OZF_CLAIM_LINES_INT_PVT dependencies on DUAL

Line 48: FROM dual;

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

Line 51: SELECT 1 FROM dual

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