193: If (p_sc_work_entity_rec.work_entity_type_code = g_bom_type
194: and p_sc_work_entity_rec.work_entity_id1 is not null) then
195: select 'X'
196: into l_dummy
197: from bom_bill_of_materials
198: where bill_sequence_id = p_sc_work_entity_rec.work_entity_id1;
199: End if;
200:
201: Exception
844: If (p_sc_work_entity_rec.work_entity_type_code = g_bom_type
845: and p_sc_work_entity_rec.work_entity_id1 is not null) then
846: select 'X'
847: into l_dummy
848: from bom_bill_of_materials
849: where bill_sequence_id = p_sc_work_entity_rec.work_entity_id1;
850: End if;
851:
852: Exception