DBA Data[Home] [Help]

APPS.PV_GE_CHKLST_PVT dependencies on DUAL

Line 102: FROM dual;

98: l_ge_chklst_rec ge_chklst_rec_type := p_ge_chklst_rec;
99: l_sequence_num NUMBER :=0;
100: CURSOR c_id IS
101: SELECT pv_ge_chklst_items_b_s.NEXTVAL
102: FROM dual;
103:
104: CURSOR c_id_exists (l_id IN NUMBER) IS
105: SELECT 1
106: FROM PV_GE_CHKLST_ITEMS_B

Line 350: FROM dual;

346: order by tl.checklist_item_id;
347:
348: CURSOR c_id IS
349: SELECT pv_ge_chklst_items_b_s.NEXTVAL
350: FROM dual;
351:
352: CURSOR c_id_exists (l_id IN NUMBER) IS
353: SELECT 1
354: FROM pv_ge_chklst_items_b