[Home] [Help]
4138: if( l_isUnitEffective and wjsi_row.end_item_unit_number is not null) then
4139: begin
4140: select 1
4141: into l_dummy
4142: from pjm_unit_numbers_lov_v pun,
4143: mtl_parameters mp
4144: where pun.unit_number = wjsi_row.end_item_unit_number
4145: and mp.organization_id = wjsi_row.organization_id
4146: and mp.master_organization_id = pun.master_organization_id;