APPS.PV_GE_CHKLST_PVT dependencies on PV_GE_CHKLST_ITEMS_VL

Line 217: FOR cur IN (SELECT MAX(sequence_num) temp_sequence_num from pv_ge_chklst_items_vl where (used_by_entity_id = p_ge_chklst_rec.used_by_entity_id ))

213: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
214: END IF;
215:
216: -- Adding the call to get the latest sequence number
217: FOR cur IN (SELECT MAX(sequence_num) temp_sequence_num from pv_ge_chklst_items_vl where (used_by_entity_id = p_ge_chklst_rec.used_by_entity_id ))
218: LOOP
219:
220: l_sequence_num := cur.temp_sequence_num;
221: END LOOP;