DBA Data[Home] [Help]

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