3126: l_sql_stmt_no := 40;
3127: -- Bug Fix 5185446 : Added distinct
3128: select distinct org.location_id
3129: into l_deliver_location_id
3130: from hr_organization_units org,
3131: hr_locations loc,
3132: po_location_associations_all pla
3133: where org.organization_id =
3134: l_kanban_card_Rec_Tbl(1).Organization_id
3141:
3142: l_sql_stmt_no := 40;
3143: select org.location_id
3144: into l_deliver_location_id
3145: from hr_organization_units org,
3146: hr_locations loc
3147: where org.organization_id =
3148: l_kanban_card_Rec_Tbl(1).Organization_id
3149: and org.location_id = loc.location_id;