DBA Data[Home] [Help]

APPS.OZF_OFFER_BACKDATE_PVT dependencies on DUAL

Line 64: FROM dual;

60: l_dummy NUMBER;
61:
62: CURSOR c_id IS
63: SELECT ozf_OFFER_ADJUSTMENTS_B_s.NEXTVAL
64: FROM dual;
65:
66: CURSOR c_id_exists (l_id IN NUMBER) IS
67: SELECT 1
68: FROM ozf_OFFER_ADJUSTMENTS_B

Line 1154: FROM dual;

1150: L_API_NAME CONSTANT VARCHAR2(30) := 'CREATE_INITIAL_ADJ';
1151: l_count NUMBER := 0;
1152: CURSOR c_id IS
1153: SELECT ozf_OFFER_ADJUSTMENTS_B_s.NEXTVAL
1154: FROM dual;
1155:
1156: CURSOR c_line_id IS
1157: SELECT ozf_OFFER_ADJUSTMENT_LINES_s.NEXTVAL
1158: FROM dual;

Line 1158: FROM dual;

1154: FROM dual;
1155:
1156: CURSOR c_line_id IS
1157: SELECT ozf_OFFER_ADJUSTMENT_LINES_s.NEXTVAL
1158: FROM dual;
1159:
1160: CURSOR c_id_exists (l_id IN NUMBER) IS
1161: SELECT 1
1162: FROM ozf_OFFER_ADJUSTMENTS_B