[Home] [Help]
3221: BEGIN
3222:
3223: select component_sequence_id
3224: into l_id
3225: from bom_inventory_components
3226: where bill_sequence_id = p_bill_sequence_id
3227: and component_item_id = p_component_item_id
3228: and operation_seq_num = p_operation_sequence_num
3229: and effectivity_date = p_effectivity_date;