APPS.PV_GE_CHKLST_PVT dependencies on PV_GE_CHKLST_ITEMS_B_S
Line 101: SELECT pv_ge_chklst_items_b_s.NEXTVAL
97: l_dummy NUMBER;
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
Line 349: SELECT pv_ge_chklst_items_b_s.NEXTVAL
345: AND b.used_by_entity_id = cv_program_id
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